M
DownloadReleasesGuidesChatbotAccountantsForumCloud Edition

Import bank statement

Most banks provide the option to download your bank transactions for import into an accounting system. In Manager.io, you can import these bank statements to streamline your accounting process.

Accessing Bank Accounts

Navigate to the Bank and Cash Accounts tab.

Bank and Cash Accounts

Starting the Import

Click the Import Bank Statement button located at the bottom-right corner of the screen.

Import bank statement

Selecting the Bank Statement

On the import screen:

  1. Choose the bank account you want to import the statement into.
  2. Select the file containing your bank statement.
  3. Click the Next button to proceed.

Next

Reviewing the Import Summary

You will see a summary displaying:

  • Bank balance before import
  • Bank balance after import
  • Number of transactions to be imported

Review the details carefully. If everything is correct, click the Import button to finalize the process.

Import

After Importing

Imported transactions from your bank statement will be recorded as either payments or receipts.

Categorizing Transactions with Bank Rules

To save time and improve accuracy, use Bank Rules to categorize imported transactions automatically. Bank Rules allow you to define criteria for assigning accounts and tax codes to transactions. For more information, see Bank Rules.

Undoing an Import

If you need to undo a bank statement import, navigate to the History screen. This allows you to reverse the import action. For details, see History.

Choosing the Right File Format

When selecting the bank statement file to import, make sure to download it directly from your bank's website. Manager.io supports multiple file formats:

Preferred Formats

For the best reliability, use one of the following formats:

  • QIF
  • OFX
  • QFX
  • QBO
  • STA
  • SWI
  • 940
  • IIF
  • CAMT.053
  • CAMT.054

Less Reliable Formats

  • XML
  • CSV

Note: If your bank offers statements in multiple formats, prioritize using the preferred formats listed above. While Manager.io can interpret various CSV formats, CSV lacks a standardized structure, which may lead to inconsistencies.

Unsupported Formats

  • PDF: Bank statements in PDF format cannot be imported, as PDFs are designed for human reading rather than machine processing.

Handling Duplicate Transactions

Duplicate transactions can occur if transaction dates change between imports. To minimize duplicates:

  • Regularly perform bank reconciliations. See Bank Reconciliations for guidance.
  • Import larger batches of transactions. Importing bank statements with more transactions helps the software detect and avoid duplicates.

Dealing with Date Formats

Transaction date errors often arise due to differing date formats. For example, the date 01-02-2024 could mean:

  • January 2nd, 2024 (mm-dd-yyyy format)
  • February 1st, 2024 (dd-mm-yyyy format)

Manager.io attempts to determine the most likely date format when importing ambiguous dates. To ensure accuracy:

  • Verify date formats before importing.
  • Check the dates after the import completes.

By following these steps, you can efficiently import your bank statements into Manager.io, ensuring your accounting records are accurate and up-to-date.