If you need a single-entry export format, please either switch your accounting (and purchase journal) to this format (more information here) or check the new 'All Payables' page and the export possibility from this page (here you will find more information).
☝🏻 Reminder - Concept of the double-entry and single-entry purchase journal
Double-entry purchase journal
Choose this format if you need both debit & credit columns. A regular payable with one expense account and one tax account will appear over 3 lines: net amount in debit against the expense account code, tax amount in debit against tax account code and total amount in credit against the account payable.
Single-entry purchase journal
Choose this format if you don't need debit & credit columns. A regular payable with one expense account and one tax account will appear in a single line (where 'net amount', 'tax amount' 'total amount' and accounting codes appear as separate columns). If you select multiple expense accounts / VAT accounts in the Prepare tab, there will be several lines in your journal for the same expense, each with their own account.
Choose and set up a journal format
If you did not set up your Accounting yet on Spendesk you have the possibility to choose between the single-entry purchase journal and the double-entry purchase journal.
For this, please go to 'Settings>Accounting' and click on "Get started". In the following tab you will see some explanations for the single-entry and the double-entry purchase journal as well as a first description on how to prepare your monthly closing with Spendesk.
Format of the single-entry purchase journal & available columns
The format of the single-entry purchase journal is modifiable via Settings>Export.
In terms of data format you can set up the following:
Date delimiter
Date format
Decimal delimiter
Column delimiter
Show column headers in the export?
Then the single-entry purchase journal file offers you the following columns:
Payable reference
Accounting entry
Payable date
Accounting date
Month
Payer
Cost center
Supplier
Description
Expense account
Counterparty
Tax code
Signed total amount
Signed net amount
Signed tax amount
Currency
Signed local amount
Local currency
(Your custom field values)