Linking Bank Statements to Twinfield Transactions
To create a connection between a bank statement and a Twinfield transaction:
Follow the instructions in the article How to Generate ID Link for Twinfield.
Start from step 5 of that article.
Select the document tag BNK instead of CUST.
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
Upload a receipt to Basecone.
Tag the document as CASH.
Process the document.
Basecone creates a separate cash transaction for the receipt.
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
Create a cash statement.
Add all supporting receipts as follow-up pages.
Tag the document as CASH.
Process the cash statement in Basecone.
Alternative Method
Instead of adding receipts as follow-up pages:
Upload receipts separately.
Merge the receipts into a single document within Basecone.
Attach the merged document to the cash statement.
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.
