Skip to main content

Twinfield: Processing Bank Statements, Cash Statements, and Journal Entries

Learn how to process bank statements, cash statements, and journal entries in Basecone when using the integration with Twinfield.This allows users to open the original bank statement directly from Twinfield.

Written by Debora Heg-Jobsen

Linking Bank Statements to Twinfield Transactions

To create a connection between a bank statement and a Twinfield transaction:

  1. Follow the instructions in the article How to Generate ID Link for Twinfield.

  2. Start from step 5 of that article.

  3. Select the document tag BNK instead of CUST.

  4. Complete the linking process.

Once configured, users can access the archived bank statement directly from the related booking in Twinfield.


Processing Cash Statements

Basecone supports the processing of cash transactions and cash statements. There are two methods available for submitting cash receipts.

Method 1: Submit Receipts Individually

Use this method when each receipt should be processed as a separate cash transaction.

Process

  1. Upload a receipt to Basecone.

  2. Tag the document as CASH.

  3. Process the document.

  4. Basecone creates a separate cash transaction for the receipt.

  5. The opening and closing cash balances are updated automatically.

Typical Use Case

This method is useful when:

  • Only a few receipts need to be processed.

  • Each receipt must be reviewed individually.

  • Transactions are entered one by one.


Method 2: Process a Cash Statement (Recommended)

This is the most efficient method when multiple receipts belong to a single cash statement.

Process

  1. Create a cash statement.

  2. Add all supporting receipts as follow-up pages.

  3. Tag the document as CASH.

  4. Process the cash statement in Basecone.

Alternative Method

Instead of adding receipts as follow-up pages:

  1. Upload receipts separately.

  2. Merge the receipts into a single document within Basecone.

  3. Attach the merged document to the cash statement.

  4. Process the statement.

Result

The cash statement is processed as:

  • One transaction in Basecone.

  • Multiple booking lines.

  • A structure that matches the lines on the cash statement.


Booking and Processing Cash Statements

Automatic Balance Calculation

When processing a cash statement, Basecone automatically calculates:

  • Opening balance

  • Cash mutations

  • Closing balance

Important Requirement

For opening balances to be calculated correctly:

✅ Process cash entries in chronological date order.

❌ Processing cash entries out of order may result in incorrect opening balances.

Entering Cash Transactions

For each line on a cash statement, specify whether the amount is:

  • Debit (cash received)

  • Credit (cash paid out)

Working with Cash Statements

When using the cash statement method:

  • Supporting receipts appear on the left side of the booking screen.

  • Cash transaction lines are entered on the right side.

  • Users can compare receipts and booking lines during processing.

  • The completed transaction is sent to Twinfield.


Accessing Supporting Receipts

After processing a cash statement:

  • Twinfield creates a link to the source document.

  • Users can retrieve and review the attached receipts directly from the accounting entry.


VAT and Customer/Supplier Limitations

For cash transactions, you can:

✅ Select and book VAT codes.

For cash transactions, you cannot:

❌ Book directly to a supplier (creditor).
❌ Book directly to a customer (debtor).


Multiple Cash Journals

Depending on the capabilities of the connected accounting system, it is possible to process transactions in multiple journals.

This can be configured through the journal settings in Basecone.


User Permissions

Only users with one of the following roles can access the booking screen:

  • Accountant

  • SME Accountant

Users without one of these roles cannot create or process cash bookings.


Processing Journal Entries

Basecone allows users to create journal entries and export them to Twinfield.

Creating a Journal Entry

Step 1: Upload Supporting Documents

Upload one or more supporting documents to Basecone.

Examples:

  • Correction documents

  • Internal accounting memos

  • Supporting calculations

  • Adjustment documentation

Step 2: Tag the Document

Tag the document as:

JNL

Step 3: Open the Booking Screen

Each document tagged as JNL becomes available for processing in the booking screen.


Journal Entry Structure

Every journal entry must contain:

  • At least one debit line

  • At least one credit line

Balancing Requirement

A journal entry must balance completely before it can be processed.

Example

Entry Type

Amount

Debit

€500

Credit

€500

Result:

✅ Difference = €0
✅ Journal entry can be processed

If the total debit and credit amounts do not match:

❌ The journal entry cannot be processed.


VAT and Customer/Supplier Limitations

For journal entries, you can:

✅ Assign VAT codes to individual posting lines.

For journal entries, you cannot:

❌ Book directly to a supplier (creditor).
❌ Book directly to a customer (debtor).


Common Use Cases for Journal Entries

Journal entries are often used for:

  • Accounting corrections

  • Reclassification entries

  • Accruals and deferrals

  • Internal adjustments

  • Year-end corrections

Supporting Documentation

A supporting document can be attached to the journal entry so that:

  • The reason for the correction remains available for audit purposes.

  • Documentation is accessible from the accounting entry.

  • Users can review the supporting evidence at a later date.


Did this answer your question?