Bank statements, matched line by line.

Bank statement import from any bank

Every bank in the Gulf exports statements a little differently. Flowyana handles that with a column mapping you set once per bank account: which column holds the date, the description and the reference, and whether amounts come as one signed column or as separate money-in and money-out columns. You also set the date format and decimal separator, and can flip the sign for banks that show withdrawals as positive numbers. If the file includes a running balance, that column can be mapped too. Save the mapping, and next month’s import is one step.

• Excel or CSV statements
• One amount column, or money in and money out
• Day-month-year, month-day-year or year-month-day dates
• Saved mapping per bank account

Suggested matches you can trust

For each statement line, Flowyana looks for unreconciled entries on that bank ledger with the same amount, dated within a week of the line. It ranks them by how close the dates are and whether the line’s reference or description mentions the entry’s reference, voucher number or party. When a line has exactly one clear match, it is an exact match, and you can confirm all exact matches at once. Everything else waits for you to choose.

• Same amount, within seven days
• Reference, voucher number and party name checked
• All exact matches confirmed in one step

Several entries, one statement line

Banks often show one deposit for several cheques or a day’s card takings, and one debit for a batch of supplier payments. Select the entries that make up the line and match them together. Flowyana checks that their total agrees with the statement line, and tells you the difference if it does not. Undo a line’s match and every entry matched to it goes back to the unreconciled list together.

Bank charges and interest from the statement

Some lines exist only on the statement: monthly account fees, transfer charges, interest earned. Instead of writing a journal and coming back to match it, create the entry from the statement line. Choose the ledger it belongs to, such as bank charges, and the branch, and Flowyana posts the voucher and matches it to the line in one step. If either part fails, neither is saved.

The reconciliation statement

Record the closing balance printed on your bank statement, and Flowyana produces the bank reconciliation statement for that date. It starts from the balance in your books, lists deposits not yet credited by the bank and payments not yet presented, and arrives at the statement balance. Your accountant or auditor can see at a glance why the two balances differ, entry by entry. Each bank account also shows when it was last reconciled and how many statement lines are still unmatched.

• Book balance to statement balance
• Deposits not yet credited
• Payments not yet presented
• Last reconciled date per bank account

Reconciled means protected

Once an entry is reconciled with the bank, its voucher cannot be changed. Anyone who tries is told the date it was reconciled, and must undo the reconciliation first. Together with close and lock dates, this keeps months you have already agreed with the bank exactly as they were. Because a bank account holds entries from every branch, reconciliation is done by someone with access to all branches.