If you need a single-entry export format, you can:
Switch Your Accounting Settings: Update your accounting and purchase journal settings to the single-entry format.
Use the 'All Payables' Page: Access the 'All Payables' page, where you can export payables in single-entry format.
Understanding Double-Entry and Single-Entry Purchase Journals
Double-Entry Purchase Journal
This format is suitable if your accounting requires both debit and credit columns.
Each payable with one expense account and one tax account will be displayed over three lines:
Line 1: Net amount in debit against the expense account code.
Line 2: Tax amount in debit against the tax account code.
Line 3: Total amount in credit against the accounts payable code.
Single-Entry Purchase Journal
Choose this format if your accounting does not require debit and credit columns.
Each payable with one expense account and one tax account will appear on a single line, with:
Net amount, tax amount, total amount, and accounting codes displayed in separate columns.
If you select multiple expense or VAT accounts in the 'Prepare' tab, the journal will include several lines for the same expense, each corresponding to its specific account.
Choose and Set Up a Journal Format
If you haven’t configured your accounting settings in Spendesk, you can choose between the single-entry purchase journal and the double-entry purchase journal.
Navigate to Settings > Accounting.
Click Get started.
In the following tab, you’ll find:
An explanation of single-entry and double-entry purchase journals.
A basic guide on preparing your monthly closing using Spendesk.
Customize the Single-Entry Purchase Journal Format
You can modify the format of your single-entry purchase journal in Settings > Export.
Configurable Data Settings:
Date delimiter
Date format
Decimal delimiter
Column delimiter
Include column headers in the export
Available Columns in the Single-Entry Purchase Journal:
The single-entry purchase journal offers the following data 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)