White Friday: up to 30% off your subscription 0days 0hrs 0min
Intagya
Pricing Blog Try free
← All articles

How do I get my bank statement into the system without typing each transaction?

| Ziad Washah · Chief Financial Officer

How do I get my bank statement into the system without typing each transaction?
The short answer

Upload the file as it came from the bank's website. In Intagya ERP you open Import bank statement, upload an Excel, CSV, OFX or QIF file and map its columns once: the template is saved for that bank. Duplicate transactions are skipped, the rules you taught the system match what they know, and statements can arrive by mail at an address of their own for each bank.

Every Sunday morning the accountant downloads last week's statement from the bank's website, opens it next to the system and types the transactions: date, description, amount. Sixty a week. In the week she is away, nobody types them.

Why do so many still type bank transactions by hand?

Because every bank's file is different. One puts debit and credit in two columns, another in one signed column, a third writes the day before the month. The accountant tries an import once, it fails, and she goes back to typing.

How does bank statement import work in Intagya ERP?

From the Accounting menu open Import bank statement, pick the bank and upload the file. The system finds the header row and the date format by itself and shows the first four rows so you choose what each column means: date, description, debit, credit, or amount, and balance.

That mapping is saved as a template for the bank. Next time you upload and import without choosing anything. If debit and credit look swapped, the balance column warns you before the import.

Import bank statement: the columns mapped on the first rows of the file, with the count of new transactions, duplicates and rule matches.
Import bank statement: the columns mapped on the first rows of the file, with the count of new transactions, duplicates and rule matches. (Arabic interface, sample data)

What if I upload the same statement twice?

Nothing doubles. Transactions already in the books are skipped. Before importing you see three figures: new transactions, duplicates to skip, and those matched by rules. So you can upload the whole month even if you uploaded half of it already.

Can the statement arrive by mail?

Yes. Each bank has its own mail address, created under Bank addresses. Send the statement there, or ask the bank to send it regularly, and it is imported with the bank's template and you get a message with the result. Because this address feeds your money, statements are accepted only from your company's users and the bank addresses you add; mail from anyone else is not imported.

One condition: incoming mail must be set up for your company. If it is not, the page says so plainly.

How does the system learn to match repeating transactions?

With Remember this. After you match a transaction by hand on the reconciliation screen, such as the monthly bank fee or a regular customer transfer, press Remember this and write: if the description contains a word and the amount is within a range, record it on this account, or let it pay the oldest open invoice of this customer.

Then choose for the rule: To review or Post directly. My view: start every rule as To review. After a month of correct matches, switch it to direct posting.

The Matching rules tab of the reconciliation screen: the rules you create with Remember this show here.
The Matching rules tab of the reconciliation screen: the rules you create with Remember this show here. (Arabic interface, sample data)

For transactions with no invoice at all, such as the electricity bill taken from the account, use Record on an account, then Remember this. Next month you will not see it.

Start this week with one bank: download last month's statement, upload it and map the columns. Then match what shows and teach the system three rules. The next statement takes half the time.

FAQ

Which file formats are accepted?

Excel, CSV, OFX and QIF, as the bank's website exports them.

Do I map the columns every time?

No. The mapping is saved as a template for each bank; change it with Change template if the bank changes its file.

Who can send statements to the bank's address?

Your company's users and the bank addresses you add only. Mail from anyone else is not imported.

Do rules post transactions without me seeing them?

Only if you set them to Post directly. A To review rule puts the transaction in the To review list for your approval.

Want to see IntagyaERP on your own workflow?

Book a demo, tell us how your business runs, and watch the system handle a real scenario from your company.

Book a demo