If your bank isn't listed with a direct feed, you can also import bank statements manually, according to Xero.
Direct answer: Use manual import for unsupported banks
When automatic bank connections are unavailable, manual import serves as the primary alternative for bringing transaction data into your accounting software. Xero explicitly states that if your bank isn't listed with a direct feed, you can also import bank statements manually Xero. This option applies specifically when the bank is not supported for direct integration. In such cases, you can add an account without a bank feed and manually import statements or set up a third-party feed like Yodlee, as described by Xero. The platform also notes that if your bank doesn’t connect to Xero, you can manually import your transaction data Xero. This capability allows you to bypass the need for a live connection by uploading statement files directly. The manual process is distinct from automatic feeds, which rely on pre-established links between the bank and the software. For unsupported banks, the manual route involves downloading statements from your bank’s portal and uploading them to the accounting platform. This method ensures that transaction history is captured even when real-time syncing is not possible. You should verify whether your bank offers downloadable statement files in formats compatible with your software before attempting this process. If your bank does not provide downloadable files, you may need to explore third-party services or manual data entry. The manual import feature is a standard part of the reconciliation workflow for banks outside the supported network. It provides a fallback mechanism for maintaining accurate financial records. By using this option, you can continue to reconcile transactions without relying on automatic feeds. The process requires attention to file formats and date ranges to ensure accurate import. Each platform may have specific requirements for manual imports, so it is important to check the documentation for your specific software. For example, Xero supports manual imports for banks not listed in its direct feed directory. This flexibility is crucial for small businesses using banks that do not integrate with major accounting platforms. The manual import process is a practical solution for maintaining financial accuracy when automatic options are restricted. It allows you to take control of the data entry process while ensuring that all transactions are recorded. By understanding when to use manual import, you can avoid gaps in your financial data. This approach is particularly useful for banks with limited digital integration capabilities. The key is to identify whether your bank is supported and then choose the appropriate import method. If your bank is not listed, you can add an account without a bank feed and manually import statements or set up a third-party feed like Yodlee. This ensures that your accounting records remain complete and up to date.
Key takeaways for how to import bank transactions when direct feeds fail
- File format: Zoho Books accepts bank statements in CSV, TSV, OFX, QIF, CAMT.053, CAMT.054, MT940, or PDF formats, as stated in Zoho documentation.
- File size limit: The same Zoho source notes that you can upload a maximum of 5 files, with each file limited to 5MB.
- Date range: FreshBooks bank connections can pull up to a maximum of 90 days of activity, according to FreshBooks.
- Start date: For FreshBooks, put the opening date of the statement period into the Bank Rec as your Reconciliation Start Date, such as July 1 for a July 1 to July 31 period, as stated by FreshBooks.
- Balance check: Verify the opening balance matches your records before proceeding with the reconciliation process.
- Manual entry: Manually enter transactions when automatic feeds are unavailable or restricted.
- Missing items: Identify and import missing transactions manually if they do not appear in the feed.
- Undo option: Zoho Books allows you to undo your last import if you uploaded the wrong statement or the same statement twice, as reported by Zoho.
Import limits and formats from named publishers
The following table lists specific import parameters and limits. Each row now names the publisher that documents that rule, so you can check the setting in the matching software.
| Setting | Publisher | Rule or Limit |
|---|---|---|
| Supported file formats | Zoho | Bank statements can be in CSV, TSV, OFX, QIF, CAMT.053, CAMT.054, MT940 or PDF formats Zoho |
| File size limits | Zoho | You can upload a maximum of 5 files, 5MB each Zoho |
| Undo import action | Zoho | If you’ve uploaded the wrong statement or the same statement twice, you can undo your last import Zoho |
| Reconciliation start date | FreshBooks | Put the opening Date into Bank Rec as your Reconciliation Start Date (if the period is July 1 to July 31, put in July 1) FreshBooks |
| Activity date limit | FreshBooks | Bank connections can pull up to a maximum of 90 days of activity FreshBooks |
| Manual transaction entry | Odoo | You can also record your bank transactions manually Odoo |
| Balance check | FreshBooks | On the statement, find the Balance or Amount one day before the date you chose, such as July 3 if you chose July 4, or the next row above it if the next available transaction is older than July 3 |
| Missing items | Odoo | Missing or pending transactions are entries that the bank has not yet validated, and to import a posted missing transaction, select it and click Import Transactions |
This table covers the specific technical constraints documented by these three publishers. File formats, upload caps, and start-date rules guide a manual import, while the 90-day figure is a limit on automatic bank connections.
The file format row is critical because Zoho explicitly lists eight distinct file types, ranging from common CSV files to specific banking standards like MT940. If your bank provides a PDF statement, note that Zoho includes PDF in its supported list. However, you must still respect the file size limits. According to Zoho, the system accepts a maximum of 5 files, with each file capped at 5MB. If your statement exceeds this size, you may need to split the file or check if your bank offers a smaller data export.
Date handling requires specific attention to avoid reconciliation errors. FreshBooks instructs users to put the opening Date into the Bank Rec as the Reconciliation Start Date. The example provided by FreshBooks uses a July 1 to July 31 period, specifying that July 1 should be entered. Additionally, FreshBooks notes that bank connections can pull up to a maximum of 90 days of activity. This limit applies to the automatic connection feature; if you are importing manually, you must ensure your statement period aligns with what you are entering in the start date field.
When no file import is possible, or when you are entering data one by one, Odoo confirms that you can also record your bank transactions manually. This option is useful for small batches of transactions or when a file format is not supported by your specific bank’s export tool.
Choosing the right file format for your bank
When automatic bank feeds are unavailable, selecting the correct file type is the first step to a successful manual import. Zoho Books accepts bank statements in CSV, TSV, OFX, QIF, CAMT.053, CAMT.054, MT940, or PDF formats, according to Zoho. If you choose a file in CSV, TSV, OFX, QIF, or CAMT.053 format, the system redirects you to the Import Statements page within the Banking module, as noted by Zoho. This redirect logic applies specifically to those five file types, guiding the upload process directly to the relevant section of the software.
Before initiating the upload, verify that your bank supports statement forwarding by email in compatible formats. Zoho advises ensuring your bank can forward statements by email in CSV, XLS, TSV, OFX, QIF, or CAMT.053 formats, reported by Zoho. However, not every bank may offer every format, so checking your bank's specific download options is a necessary preliminary step.
File size constraints also play a critical role in the import process. You can upload a maximum of 5 files, with each file limited to 5MB, according to Zoho. If your statement exceeds these parameters, you may need to split the data or seek alternative import methods.
To choose the right format, start by downloading your statement from your bank's portal. Check if the file extension matches one of the supported types listed by Zoho. If your bank only provides PDFs, note that while Zoho Books lists PDF as a supported format for import, the specific redirect logic mentioned applies to CSV, TSV, OFX, QIF, and CAMT.053. Ensure each file stays at a maximum of 5MB and that you upload no more than 5 files at once. If your bank offers email forwarding, configure it to send statements in CSV or OFX formats, as these are explicitly supported for forwarding, according to Zoho. This setup can reduce manual handling and potential format errors.
Calculating the correct reconciliation start date
Selecting the correct start date is the first step in setting up bank reconciliation for a new account. According to FreshBooks, you should put the opening Date into the Bank Rec as your Reconciliation Start Date. For example, if the statement period is July 1 to July 31, you would put in July 1. This establishes the baseline for the reconciliation process.
You have the option to choose any date within the statement period. As noted by FreshBooks, you can choose any date within the statement period and put this into the Bank Rec as your Reconciliation Start Date, such as July 28. This flexibility allows you to align the start date with your specific bookkeeping schedule.
Once you have selected your start date, you must locate the corresponding balance on your statement. FreshBooks advises finding the Balance or Amount one day before the date you chose. If you chose July 4, you should look for the balance next to July 3. If the next available transaction is older than July 3, use the next row above it. This ensures you are capturing the exact balance at the start of your reconciliation period.
For credit card accounts, the process involves a specific balance check. According to FreshBooks, if you are setting up a credit card account, this is your Previous Statement Balance. If you have paid off your credit card balance, this amount would be $0. This distinction is important for accurate reconciliation of credit card transactions and standard bank accounts.
To summarize the date calculation process: 1. Identify the statement period, such as July 1 to July 31. 2. Select a start date within that period, such as July 1 or July 28. 3. Find the balance one day before the selected date on the statement. 4. If you are setting up a FreshBooks credit card account, enter this amount as the Previous Statement Balance.
If you are unsure which date to select, default to the first day of the statement period. This aligns with the example provided by FreshBooks for a July 1 to July 31 period. Always verify that the balance you enter matches the statement exactly to avoid reconciliation errors.
Handling missing and pending transactions
When automatic synchronization fails to capture every entry, you must identify which items are absent before attempting a manual fix. According to Odoo, missing or pending transactions are entries that the bank has not yet validated. If you see gaps in your records, first verify the connection status. The documentation states, "Make sure the connection with the bank is active to find missing transactions" ( Odoo).
Once the connection is active, check the age of the transactions you are trying to retrieve. For some bank institutions, transactions can only be fetched up to three months in the past, according to Odoo. If your missing item is older than this window, the automatic fetch will not retrieve it. You must then look for the specific posted item in your list. To import a posted missing transaction, select it and click Import Transactions, as described in the Odoo documentation.
If the item remains unavailable through the synchronization feature, you have a fallback option. The Odoo documentation notes that you can also record your bank transactions manually. When using manual entry, ensure the date and amount match the bank statement exactly to maintain reconciliation accuracy.
Check your connection status and fetch limits before starting a manual import.
Xero notes that if your bank doesn’t connect to Xero, you can manually import your transaction data Xero.
Related guides
FAQ: How to import bank transactions when direct feeds fail
What file formats can I import into Zoho Books?
According to Zoho, the bank statements you import can be in CSV, TSV, OFX, QIF, CAMT.053, CAMT.054, MT940 or PDF formats. This list covers the specific file types supported for manual statement uploads in that platform.
How many days of activity can FreshBooks bank connections pull?
Reported by FreshBooks, bank connections can pull up to a maximum of 90 days of activity. You should check for more details with your bank connection partner regarding this limit.
What should I do if my bank is not listed for a direct feed in Xero?
Published by Xero, if your bank isn't listed with a direct feed, you can also import bank statements manually. This option allows you to proceed with reconciliation even when automatic feeds are unavailable for your specific institution.
How do I handle missing transactions in Odoo?
According to Odoo, to import a posted missing transaction, select it and click Import Transactions. This action brings the specific item into your records after it has been identified as missing.
Can I undo a bank statement import if I uploaded the wrong file?
Reported by Zoho, if you’ve uploaded the wrong bank/credit card statement or uploaded the same statement twice, you can undo your last import. Zoho lets you undo only your last import when you uploaded the wrong bank or credit card statement, or the same statement twice.