Skip to main content
Single-entry purchase journal
Updated this week

If you need a single-entry export format, you can:

  1. Switch Your Accounting Settings: Update your accounting and purchase journal settings to the single-entry format.

  2. 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.

  1. Navigate to Settings > Accounting.

  2. Click Get started.

  3. 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)

Did this answer your question?