The Scenario
You track expenses in an Excel workbook because it's easier than logging into the accounting platform every time you buy something. By the end of April there are 30 rows: date, gross amount, informal category label, tax rate, receipt status. Your accountant has flagged this three times — the expenses need to be in Lexoffice as vouchers before the VAT submission window closes on Friday. It's Wednesday afternoon.
The bad version:
- Open Lexoffice, click New Expense Voucher, enter the date, switch to net amount, calculate the net from the gross manually, pick the posting category from the dropdown (which uses German accounting codes, not your informal labels), set the tax rate — and repeat for all 30 rows
- Get confused around row 12 about whether "software" maps to the "Andere Aufwendungen" category or a more specific code, spend 20 minutes in the Lexoffice help docs, and make a judgment call that your accountant will probably query anyway
- Submit the vouchers, get a reply on Thursday morning asking you to re-categorize eight of them before submission
Wednesday afternoon became a Thursday accounting problem.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the expense rows and creates the Lexoffice vouchers directly — handling the net amount calculation and category mapping.
Open the expense tracking workbook and type:
Create an expense voucher in Lexoffice for each row in this workbook using date in column A, amount in B, posting category in C, and tax rate in D
What You Get
- A Lexoffice expense voucher created for each row, with date, amount, posting category, and tax rate mapped correctly
- The Lexoffice voucher ID written back into column E for each successful row
- Error notes for rows where the posting category didn't match a valid Lexoffice category — so you know which ones to fix before Friday
What If the Data Is Not Quite Ready
Only pending rows should be uploaded
For every row where Receipt Status in column E is "pending upload" create a Lexoffice voucher with the net amount in column C and posting category in column D
Amounts are gross and Lexoffice requires net
For each row, calculate the net amount from the gross in column B using the tax rate in column D, then create a Lexoffice expense voucher using date in A, the calculated net amount, and posting category in C
Informal category labels need to be mapped to Lexoffice codes
Map the expense categories in column C to their Lexoffice posting category equivalents, write the mapped codes into column E, then create a Lexoffice expense voucher for each row using date in A, amount in B, and the mapped category in E
Full upload pass in one shot
For all rows where column E is "pending upload": calculate the net from the gross in column B using the tax rate in column D, map the informal category in column C to the correct Lexoffice posting category, create an expense voucher using date in A, the net amount, and the mapped category — write the voucher ID into column F and mark column E "uploaded"
One prompt handles the whole monthly expense upload before the VAT window closes.
Try It
Get the 7-day free trial of SheetXAI and open your expense tracking workbook — ask it to create the Lexoffice vouchers and you'll be done well before Friday. You can also look at how to bulk-create credit notes, or return to the full Lexoffice integration overview.