Sign in Start free trial
Help centre › Modules

Bank sync between Payment Accounts and Accounting

How EZI ERP keeps your Payment Accounts and the Cash & Bank heads in the chart of accounts showing the same balances, automatically.

What it is

EZI ERP has two places that track cash and bank money:

  • Payment Accounts (left menu Payment Accounts > List Accounts) - the simple list of your bank accounts and cash boxes, used on sales, purchases and expenses.
  • The Cash & Bank heads in Accounting > Chart of accounts - the double-entry view your accountant uses.

Bank sync is a background job that keeps the two identical. Each payment account has exactly one matching head under Cash & Bank, and every payment shows up on both sides with the same amount.

Why you would use it

Without it, staff record a customer payment in one place and the accountant sees a different balance in the other. Bank sync removes that double work and stops the two sets of figures drifting apart. Your Balance Sheet bank balance then matches what you see in Payment Accounts.

How it works

You do not have to press anything. Once bank sync is switched on for your business, the system checks for changes about every minute and only does work when something has changed. It then:

  1. Links accounts to heads. Every open payment account gets its own head under Cash & Bank. If a head with the same name already exists, it is used. If not, a new head is created with the payment account's name.
  2. Creates payment accounts from heads. If your accountant opens a new active head under Cash & Bank, a matching payment account is created for it.
  3. Posts payments. Each payment (on a sale, purchase or other transaction) is the master record. It creates one line on its payment account and the matching bank line in the chart of accounts.
  4. Handles payments with no account. A payment that has no payment account selected is posted to a head called Unassigned payments (no payment account). Check this head from time to time and fix those payments.
  5. Handles bulk payments. When one payment is split over several invoices, only the main payment moves cash. The split parts do not add extra bank lines.
  6. Posts expenses. An expense is booked to its expense head against Accrued Expenses. Each payment of that expense then clears Accrued Expenses against the bank it was paid from.
  7. Copies deposits, transfers and opening balances. Those made in Payment Accounts become journal entries in Accounting. Opening balances go against Opening Balance Equity.
  8. Mirrors journal entries. A journal entry your accountant makes on a bank head is copied into Payment Accounts.
  9. Deletes both sides. Deleting the record on one side removes it from the other.

How to use it

  1. Make sure the Accounting module is set up and your chart of accounts has a Cash & Bank group (see Accounting).
  2. Ask your administrator to switch bank sync on for your business.
  3. Keep working as normal: add sales, purchases, expenses and payments, and choose the right payment account each time.
  4. Compare Payment Accounts > List Accounts with Accounting > Chart of accounts. The balances for each bank should match.
  5. Check the Unassigned payments head. Edit any payment found there and choose its payment account.

Tips / common questions

  • Closed accounts. A closed payment account is left out of the books unless it was already linked to a head.
  • Renaming. Give a bank the same name in both places to avoid a duplicate head being created.
  • Is it safe to run often? Yes. The job only fixes differences, so running it again changes nothing if everything already matches.
  • Mapping in settings. The payment account to head link is also saved when you map accounts in Accounting > Settings.
  • Balances still differ? Your administrator can run a "dry run" that shows what the sync would change without saving anything.

Related: Payment accounts, Expenses, Sales, Purchases.