Overview
The Reconciliation module in DizLog helps you manage your bank and cash accounts and reconcile them with your accounting records.
You open it from:
Financials → General Accounting → Reconciliation.
Inside this module you will see several tabs:
Bank Accounts – set up the bank or cash accounts you want to reconcile.
Reconcile – perform a bank reconciliation for a selected account.
Reconcile Report – view the history of past reconciliations and download copies.
Bank Rules – define simple rules to automatically categorise imported bank transactions.
Chart of Accounts – see and manage your account categories that transactions post to.
These tabs work together with other parts of DizLog, such as General Ledger, Journal Entry, Accounts Payable, and Financial Statements (Bank Transactions), which supply the accounting entries and imported bank lines used during reconciliation.
Key Features
1. Bank account setup (Bank Accounts tab)
List of existing bank accounts with columns such as Account Name, Bank Name, Account Number, Type, Currency, and Created At.
Add New Account button to create a new financial account.
Ability to import bank statements for a selected account using an Import financial statements modal that lets you download a CSV template and upload completed files.
2. Bank reconciliation (Reconcile tab)
Choose a financial account to reconcile.
Enter Beginning balance, Ending balance and Ending date for the statement you are reconciling.
See a list of ledger transactions from the Ledger for the selected account and period.
Filter the list to see All, Payments, or Deposits only.
Mark items as cleared and view summary figures such as Beginning balance, Ending balance, Total payments, Total deposits, Cleared balance, and Difference.
Complete the reconciliation when the difference is zero and see a Reconciliation finished confirmation modal.
3. Reconciliation history (Reconcile Report tab)
View a list of reconciliations by account, with columns such as Statement Ending Date, Reconciled On, and Ending Balance.
Download reconciliation statements as PDF or CSV when files are available.
4. Bank rules (Bank Rules tab)
Create rules that apply to imported bank transactions for a specific Bank/Financial Institution and bank account.
Rules can filter on fields like Description and apply conditions such as contains a value.
Each rule assigns a Transaction Type (for example, Expense) and a Category (general ledger account) and Payee.
5. Chart of accounts (Chart of Accounts tab)
Lists main account groups such as EXPENSE, ASSETS, INCOME, LIABILITIES, and EQUITY, showing their running balances and status.
Add New Account Type / Create Account form where you define account name, number, parent account, currency, opening balance, and description.
Posting Rules section to map event names (for example, SALE) to debit, credit, and optional tax accounts used across modules such as Sales or Accounts Payable.
6. Connected modules
The Reconciliation module relies on, or feeds into, these other modules:
Financial Statements (Bank Transactions) – where you import and edit individual bank transactions that later appear for matching and reconciliation.
General Ledger – holds all ledger entries by account; the Reconcile screen uses these ledger entries to show payments and deposits for the selected period.
Journal Entry – manual journals you post here also flow into the ledger and will appear during reconciliation.
Accounts Payable / Accounts Receivable – bills, payments and invoices recorded there produce ledger entries that show up when reconciling bank accounts.
Reconcile History – backend service that stores reconciliation results and powers the Reconcile Report tab.
Getting Started
Step 1 – Open the Reconciliation module
From the left menu, go to Financials.
Under General Accounting, click Reconciliation.
You will land on the Transactions page with tabs for Bank Accounts, Reconcile, Reconcile Report, Bank Rules, and Chart of Accounts.
Step 2 – Set up your bank accounts
Stay on the Bank Accounts tab.
Click Add New Account.
Fill in the fields such as:
Account Name
Bank Name
Account Number
Type (for example, bank, cash)
Currency
Save the record. The new account appears in the Bank Accounts list with its details.
Step 3 – Import bank statements / transactions
There are two places where you can import your bank transactions:
A. From Bank Accounts → Import
On Bank Accounts, choose the account you want.
Open the Import financial statements option (for example via an Import button or menu).
In the modal:
Click Download template file to get the CSV format expected by the system.
Fill the template with your bank statement lines.
Drag and drop or choose the file in the CSV Dropzone area.
Click Upload. If no file or account is selected, you will see an error message asking you to select them.
On success, you will see an Upload Successful message and the modal closes.
B. From the Financial Statements (Bank Transactions) screen
From the dashboard routes, open Bank Transaction / Financial Statements.
Use Import Statement to upload CSV files and add many transactions at once.
You can also click Add New Transaction to enter a single bank transaction manually.
Once imported, these transactions can be matched to your ledger and used in reconciliation.
Step 4 – Review your Chart of Accounts (optional but recommended)
Go to the Chart of Accounts tab.
Review the existing account categories (EXPENSE, ASSETS, INCOME, LIABILITIES, EQUITY).
To add a new category, click Add New Account Type and complete the Create Account form, including any Posting Rules you need for automatic postings.
How to Use
1. Perform a bank reconciliation
Follow this workflow every time you want to reconcile a statement period for a bank account.
Step 1 – Open Reconcile tab
On the Transactions page, click the Reconcile tab.
Step 2 – Choose account and statement details
In the Account dropdown, select the bank account you want to reconcile.
Enter:
Beginning balance – the opening balance from your bank statement.
Ending balance – the closing balance from the statement.
Ending date – the statement end date.
These values will be used in the summary to show if everything matches.
Step 3 – Review transactions list
The system loads ledger transactions for the selected account around the date range.
Use the view filter to switch between All, Payments, or Deposits.
Optionally adjust the date filter (if available) to narrow down the list to the statement period.
Step 4 – Mark items as cleared
For each bank statement line, look for the matching ledger transaction.
Mark the transaction as cleared (for example, using a checkbox in the list).
As you select items, the Calculation summary at the side or bottom updates:
Total payments cleared
Total deposits cleared
Cleared balance
Difference between cleared balance and your ending balance.
If the Difference is not zero, some items are still unmatched or balances are wrong.
Step 5 – Finish reconciliation
When the Difference reaches zero, click the button to complete or submit the reconciliation (as indicated on screen).
A Reconciliation finished modal confirms the process is complete.
The completed reconciliation appears in the Reconcile Report tab for future reference.
2. View reconciliation history and download reports
Open the Reconcile Report tab.
Select an Account and a Report period if filters are available.
The table lists all reconciliations for that account, showing:
Statement ending date
Reconciled on date
Ending balance
Use the PDF or CSV buttons on a row to download copies of the reconciliation statement.
3. Manage bank rules
Bank rules help you automatically categorise imported bank transactions.
Go to the Bank Rules tab.
Click Add New Rule.
Enter:
Rule name.
Bank/Financial institution.
Whether the rule applies to Money In or Money Out, and which bank account(s).
Under Conditions, choose a field (such as Description) and a condition (such as contains) and type the value that should trigger the rule.
Under Then assign, choose:
Transaction type (for example, Expense).
Category (ledger account).
Payee (supplier or contact).
Save the rule.
When bank transactions are imported that meet these conditions, they are automatically assigned to the selected category and payee.
4. Maintain chart of accounts and posting rules
In Chart of Accounts, expand a main account group (for example, EXPENSE) to see its subaccounts and running balances.
To add a new account:
Click Add New Account Type.
Fill in Account Name, optional Account Number, Parent Account, Currency, Opening Balance, and Description.
In the Posting Rules section, for each event name (such as SALE), set which accounts will be debited and credited and, if needed, which tax account to use.
These settings control how transactions from Sales, Accounts Payable, and other modules hit your ledger and appear in reconciliation.
Troubleshooting
1. I cannot upload my bank statement file
Possible causes and checks:
No file selected – the upload modal shows an error like “Please select a file” if you click Upload without a file. Re-open the modal and choose a CSV file before uploading.
No account selected – you must choose a bank account for the upload; if not, you will see an error asking you to select an account.
Server error – if something goes wrong on upload, you may see a message similar to “Something went wrong. Please try again later.” Try again after a few minutes or contact your system administrator.
2. Transactions are missing on the Reconcile screen
Check that you selected the correct Account at the top.
Confirm the date range and ending date cover the statement period you expect.
Make sure the related entries exist in Financial Statements (Bank Transactions) and General Ledger / Journal Entry / Accounts Payable; if a bill payment or journal hasn’t been posted, it will not appear for reconciliation.
3. The difference in the summary never reaches zero
Re-check Beginning balance and Ending balance against the bank statement; a typo here will prevent the difference from balancing.
Make sure all statement transactions for the period are imported and matched.
Look for duplicated or missing entries in the ledger (for example, a payment posted twice).
4. I can’t see my reconciliation in Reconcile Report
Confirm you completed the reconciliation and saw the Reconciliation finished confirmation.
In Reconcile Report, select the same Account and make sure the Report period includes the statement ending date.
5. My bank rules are not applying
Check that the rule is created for the correct Bank/Financial Institution and bank account.
Verify the conditions (for example, Description contains “Rent”) actually match the imported transaction text.
Ensure the rule’s Transaction Type and Category are valid and active in the Chart of Accounts.
By following this guide, you can use the Reconciliation module in DizLog to keep your bank accounts, ledger, and financial reports aligned, while taking advantage of connected modules like Bank Transactions, General Ledger, Accounts Payable, and Chart of Accounts.