Wiki
Bank reconcilation
Bank statement reconciliation is a process of verifying the amounts in bank statement with the company’ Cash account or vice versa. The benefit of this report is it will allow you to compare reports of bank with the reports of your company cash account in order to uncover any possible discrepancies. Sometimes there may be differences between your company cash account and Bank statement because you may write hundreds of checks each month and make several deposits. Some items appear in your Cash account in different months with the bank statement. In kpi.com you can import your bank statements into the system and reconcile them with the company Cash account and even if your company Cash account does not have some transactions you can record a new transaction and reconcile it. For reconciling bank statement with your company Bank account in kpi.com, follow these instructions.
Go to Accounts>>Bank Account>>Click the actions and choose Import Transactions. Before uploading the statement save the file in .CSV or .OFX format. Finally upload the file into the system.
Once you have uploaded the file, following pop-up window will appear with the transactions list where you can match transactions with the bank transactions, which already have been created in kpi.com account or Create New Transaction.
Further, when you click Find and Match you can select transactions to reconcile by ticking transaction line and clicking Reconcile. Moreover, in this pop-up window users will be able to filter transactions by Amount more/less and set period.
If some transactions are not recorded in the system, you can create a new transaction in order to reconcile with the bank statement. For creating new transactions click on Create New transaction, then fill the required fields and save it.
After you have reconciled all the transactions with the bank statement your company Bank account balance at kpi.com will be the same with the bank account balance in your Bank.
Created by Aziza Israilova, April 2019
See also
- Purchase Order for Fixed Assets
- Goods Delivered Notes
- Sales Quote
- Sales Order
- Sales Invoice
- Recurring Invoice
- Request for quote
- Request for purchase
- Purchase Order
- Purchase Invoice
- Recurring Bills
- Fixed Assets
- Company Expense Claims
- Employee Expense Claims
- Customer Center
- Supplier Center
- Products & Services Overview
- Bank Accounts
- Supplier Access
- VAT Reverse Charge Mechanism
- Setting Barcode for a Product
- Items Table
- Run Time Calculation of Exchange gain/loss
- Exporting to Excel and PDF
- Timesheet Invoice
- Budget per Department
- VAT Return
- Dividends Payable
- Assembly Products
- Add New Assembly Item
- What is Non-Inventory Item?
- Add New Non-Inventory Item
- FIFO method of inventory valuation
- What is Inventory Item?
- Add New Inventory Item
- Products/Services Import
- Add New Product/Service
- Intercompany Purchases
- Creating Intercompany Sales Invoice
- Intercompany Sales
- Workflow of Expense Claims
- Purchases / Bills Overview
- Timesheet based Invoice
- Progress Invoicing
- How to convert Sales Quote to Order, Invoice & Project
- Sales Overview
- Serial Numbers
- Accounting Overview
- Landing Cost
- Mark PO as Open
- Purchase Order Actions
- Receive Purchase Order
- Send Purchase Order
- Importing Customer Accounts