If you have multiple transactions that you’d like to add to your bank reconciliation, you can import them in bulk with a CSV file, according to FreshBooks.
How to import bank statements in FreshBooks, Zoho, Manager, and Xero
Key Takeaways
- FreshBooks limits CSV imports to 500 transactions in one file.
- Zoho Books supports seven file formats including CAMT.053 and CAMT.054.
- Manager warns about date ambiguities for days 1-12 and two-digit years.
- Xero pulls transaction data automatically without requiring file uploads.
- Zoho Books adds imported transactions as uncategorized entries.
Getting bank transactions into your accounting software efficiently is a critical step for preparing the month-end close. Each platform handles data ingestion differently, requiring specific attention to file formats, date rules, and duplicate checks. FreshBooks allows you to import multiple transactions in bulk using a CSV file for bank reconciliation, according to FreshBooks. This bulk capability is essential for bookkeepers who need to process high volumes of data without entering each line item individually.
The seven import rules covered in this guide address the specific constraints and features of these four platforms. First, file format limits determine which data types each system accepts. Second, date format rules prevent parsing errors that can skew your financial records. Third, duplicate transaction checks help maintain data integrity by identifying repeated entries. Fourth, manual entry options provide a fallback when automated imports fail or are unavailable. Fifth, bank feed automation reduces manual effort by pulling data directly from financial institutions. Sixth, import location paths dictate where within the software you initiate the upload. Finally, preview and confirmation steps allow you to verify data accuracy before the import is committed.
File format and size constraints
FreshBooks sets a strict ceiling on the volume of data you can process in a single manual upload. When creating the CSV file for bank reconciliation, ensure the file has no more than 500 transactions maximum, according to FreshBooks. This limit applies specifically to the CSV structure used for adding, editing, or deleting manual transactions within the bank reconciliation module. If your statement exceeds this threshold, you must split the data into separate files to comply with the system's capacity constraints.
Zoho offers a broader range of accepted file structures for manual bank statement imports. You can upload the file in CSV, TSV, XLS, OFX, QIF, CAMT.053, and CAMT.054 file formats, according to Zoho. Zoho explicitly supports users who prefer to import their bank statements manually rather than relying solely on automated feeds, according to Zoho.
Check your current bank statement file format against the specific requirements for your chosen software before attempting the import. Verify that your file extension matches one of the supported formats listed for your platform. For FreshBooks, confirm the transaction count is under the 500-transaction limit. For Zoho, ensure your file is saved in one of the seven supported formats. If your file does not meet these criteria, convert it to a compatible format or split the data before uploading.
Date formats and ambiguity risks
FreshBooks accepts specific date structures within the Date column for manual transaction imports. The dates under the Date column are not written with dashes (-) or slashes (/) in between numbers, and 01/17/2020 and 01-17-2020 are accepted, according to FreshBooks. This rule applies specifically to the manual transaction entry process within bank reconciliation. The source does not specify other accepted formats, so sticking to the documented examples is the safest approach for clean data ingestion.
Manager software identifies potential risks associated with how financial institutions implement certain import formats. Some import formats (or poor implementation of them by financial institutions) also have the potential for date ambiguities when transactions are limited to early in a month (days 1 - 12) or represent years with only two digits according to Manager. This ambiguity risk exists because standard date parsing can confuse day and month values when the day number is less than 13. Additionally, two-digit year representations can lead to incorrect century interpretations. Users of Manager should check their statement files for these specific patterns, particularly if the statement covers days 1-12 or uses two-digit years. If your bank provides statements with two-digit years or early-month dates, verify the software interprets them correctly before finalizing the import.
Import settings for each publisher
The rows below list file limits, date warnings, and import methods for Xero, Zoho, Manager, and FreshBooks.
| Publisher | File Format/Size Limit | Date Rule/Warning | Import Method |
|---|---|---|---|
| Xero | Not stated | Not stated | Automatic bank connection so you do not need to upload bank statements |
| Zoho | CSV, TSV, XLS, OFX, QIF, CAMT.053, and CAMT.054 | Not stated | Manual import, or automatic bank feeds when the bank supports them |
| Manager | Not stated | Days 1-12 or two-digit years | Bank and Cash Accounts tab, then Choose File |
| FreshBooks | CSV of no more than 500 transactions | Dates under the Date column are not written with dashes or slashes in between numbers | Bulk CSV import for bank-reconciliation manual transactions |
Xero accounting software easily connects to your bank to bring your bank transactions into Xero automatically, according to Xero. Xero pulls in all your transaction data so you don’t need to upload bank statements, according to Xero.
Handling duplicates and manual entries
When preparing bank data for the month-end close, you must account for how each platform manages existing records and new inputs. Manager warns that bank statement imports have the potential to duplicate transactions already entered either manually or by prior import, according to Manager. To mitigate this risk, Manager has the ability to recognize most duplicate transactions, based on type, date, and amount, according to Manager. This recognition logic relies on matching those three specific data points to identify potential overlaps before they clutter your records.
For platforms where you might need to bypass automated feeds or file uploads, manual entry remains a viable option.
In Zoho Books, the status of imported data requires immediate attention to prevent categorization errors. The transactions in your bank statement will be added as uncategorized transactions, according to Zoho. Because these entries arrive without assigned accounts, you must review and categorize them promptly to maintain accurate financial reporting. The combination of Manager’s duplicate detection and Zoho’s uncategorized status highlights the need for a structured review process after import.
To manage these risks effectively, follow these steps:
Bank feeds and manual uploads
Automatic bank feeds and manual file uploads represent two distinct workflows for moving transaction data into accounting software. The choice between these methods depends on whether your bank supports direct connectivity features within your specific platform.
Automatic Bank Feeds
Zoho Books offers a bank feeds feature that allows you to fetch bank statements automatically if your bank supports this connectivity, according to Zoho. This automation eliminates the need for manual file handling for supported institutions. Similarly, Xero pulls in all transaction data so you don’t need to upload bank statements, according to Xero. Both platforms prioritize reducing manual intervention by establishing a direct link with financial institutions where available.
Manual Upload Paths
For platforms where automatic feeds are not the primary method or where specific file handling is required, manual navigation is necessary. To import a bank statement into Manager, go to the Bank and Cash Accounts tab, according to Manager. Once in this section, click Choose File to browse to the downloaded statement (or modified *.csv file) you want to import, according to Manager. This process requires the user to locate and select the specific file from their local storage before the import can proceed.
Choosing Your Workflow
When preparing for the month-end close, determine if your bank is supported by the automatic feed options in Zoho Books or Xero. For Manager, prepare the statement file locally, open the Bank and Cash Accounts tab, then click Choose File. For Zoho Books, click Import Statement on the top right corner of a bank's Details page. Review your bank’s supported platforms to decide whether to rely on automatic fetching or manual file selection.
For broader comparisons of these tools, see Import bank statements: compare 4 bookkeeping tools.
Preview and confirmation steps
In Zoho Books, on the Preview page, check the preview and click Import. In Zoho Books, the system displays a dedicated Preview page where you can review the parsed entries before they become permanent records. On this screen, you should check the preview to ensure dates, amounts, and descriptions match your source document, then click the Import button to finalize the process, according to Zoho. This step allows you to catch formatting errors or misaligned columns before they clutter your bank feed.
FreshBooks handles the confirmation phase differently by focusing on session stability during the upload. Once your file is ready, keep in mind that importing a CSV file can take up to 15 minutes and you must remain logged into your FreshBooks account while the file is importing, or your import will be interrupted, according to FreshBooks. You must remain logged into your FreshBooks account while the CSV file is importing, or your import will be interrupted. Plan your month-end close workflow to account for this potential wait time, especially if you are processing multiple bank accounts in sequence.
FAQ: How to import bank statements in 4 bookkeeping apps
What is the maximum number of transactions FreshBooks allows in a single CSV import?
FreshBooks limits a single CSV file to a maximum of 500 transactions when creating the file for import, according to FreshBooks. If your statement exceeds this count, you must split the data into multiple files to comply with this specific constraint.
Which file formats does Zoho Books support for manual bank statement imports?
Zoho Books accepts manual uploads in seven distinct file formats: CSV, TSV, XLS, OFX, QIF, CAMT.053, and CAMT.054, according to Zoho. You should verify your bank’s export capability against this list before initiating the upload process.
How does Manager software handle potential date ambiguities in imported statements?
Manager warns that some import formats or poor implementations by financial institutions can create date ambiguities for transactions dated between days 1 and 12, according to Manager. Some import formats can create date ambiguities when years are represented with only two digits.
What happens to transactions in Zoho Books immediately after a successful import?
Zoho Books adds the imported transactions as uncategorized transactions immediately after a successful import, according to Zoho. You will need to categorize these entries manually to complete the reconciliation process.