Automated Posting of Bank Statements
Travelmanager helps you manage open items efficiently by comparing bank statement entries with outstanding receivables. This reduces manual work and helps avoid posting errors.
How It Works
- Export the bank statement for the required period as a CSV file from your bank.
- In the backend, open
Accounting > Import Payments. - Upload the generated CSV file.
- Travelmanager compares the statement entries with open items and suggests possible matches for each row.
- Assign all reliable matches at once and then process the remaining statement rows manually.
Reliable Matches
Reliable matches are statement entries where the transferred amount exactly matches the outstanding receivable. In addition, the payment reference must contain a matching invoice number, customer number, or booking number.
Reliable matches can be assigned in one step. This reduces manual effort and speeds up the posting process while keeping the status of each statement entry transparent.
Additional Optimization Options
Each statement row can be processed individually. In addition to assigning a row to an open item, you can also hide rows that are not related to a booking.
This helps you keep the import view focused and makes it easier to process only the entries that are relevant for accounting.