The Scenario
You freelance across four clients. Every month you track your expenses in a Google Sheet — date, amount, category, tax rate, receipt notes — because your accountant told you to keep a clean record. But "keeping a clean record" and "getting them into Lexoffice as vouchers" are two different things. The sheet has 30 rows for April. Your accountant wants the vouchers in Lexoffice before the end of the week or the month-end close gets pushed.
The bad version:
- Open Lexoffice, navigate to Vouchers, click New Expense Voucher, enter the date, amount, posting category, tax rate — for each of the 30 rows
- Discover that the posting categories in your sheet use your own shorthand ("travel," "software," "meals") and Lexoffice uses its own German accounting category codes, so you have to look up the correct category for each row
- Get to expense 20 and realize you entered three amounts as gross instead of net because you forgot to switch the toggle, and now you have to void and re-enter them
Thirty expense vouchers. An afternoon of corrective data entry. And next month there will be another 30.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the expense rows and creates the Lexoffice vouchers directly — no form navigation, no category lookup.
Open the expense tracking sheet and type:
Create an expense voucher in Lexoffice for each row in this sheet 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 any rows where the posting category didn't match a valid Lexoffice category — so you know exactly which ones need a category correction
What If the Data Is Not Quite Ready
Only the 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 in the sheet are gross and need to be converted to net
For each row in this sheet, 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 column A, the calculated net amount, and posting category in column C
The posting category column uses informal labels that need to be mapped to Lexoffice codes
Map the expense categories in column C to their Lexoffice posting category equivalents (travel, software, meals, equipment), 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: normalize, map, create, and log in one shot
For all rows where column E is "pending upload": calculate the net amount 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 the date in A, the net amount, and the mapped category, then write the resulting voucher ID into column F and mark column E as "uploaded"
One prompt handles the entire monthly expense upload.
Try It
Get the 7-day free trial of SheetXAI and open your expense tracking sheet — ask it to create the Lexoffice vouchers and your accountant will have everything they need before the deadline. You can also look at how to bulk-create credit notes, or return to the full Lexoffice integration overview.