Import bank statement

Most banks allow downloading bank transaction records in electronic formats suitable for import into accounting software. Manager.io supports importing these statements to streamline your accounting workflow.

Importing your bank statement

To import a bank statement into Manager.io, follow these steps:

1. Navigate to the Bank and Cash Accounts tab:

2. Click the Import bank statement button located in the bottom-right corner:

3. On the following screen, select your bank account and upload the bank statement file you previously downloaded from your bank's website, then click Next:

4. Manager.io displays a summary including your bank balances before and after the import, as well as the number of transactions ready for import. If you're satisfied, proceed by clicking on the Import button:

After confirming import, the downloaded transactions will be recorded as payments or receipts in Manager.io.

Supported file formats

Manager.io can import bank statements in several formats, including:

• Preferred (most reliable): QIF, OFX, QFX, STA, 940, CAMT530
• Accepted, but less reliable: XML, CSV

Note that PDF files cannot be imported, as PDFs are designed strictly for human readability and not for automated systems.

If your bank provides multiple file formats, always prioritize the preferred formats (QIF, OFX, QFX, STA, 940, and CAMT530) over XML and CSV. Although Manager.io can interpret CSV format statements with various layouts, be aware that CSV format has no standardized structure, and results can vary.

Handling imported transactions

• To efficiently organize your imported transactions, use Bank Rules to quickly categorize payments. For details, see Bank Rules.
• If you wish to reverse an import of bank transactions, it's possible through Manager.io's History feature. See History.

Avoiding duplicate transactions and date confusion

Duplicate transactions can occur if your bank makes date adjustments between imports. Regularly perform Bank Reconciliations to identify and resolve these duplicates promptly. For detailed instructions, refer to Bank Reconciliations.

Imported transaction date confusion is a common issue due to varying date-format standards across countries. For example, the date "01-02-2024" could represent either January 2 (MM-DD-YYYY) or February 1 (DD-MM-YYYY). Manager.io attempts to determine the correct format if dates are ambiguous. To reduce ambiguity, import bank statements containing a higher number of transactions—this helps the software correctly identify and consistently interpret date formats, avoiding duplicates.

By following these guidelines, importing statements to Manager.io can significantly streamline your accounting tasks and improve financial record accuracy.