Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
cats:procedures:accounting:bankrec [2014/10/01 16:33] – amanda | cats:procedures:accounting:bankrec [2017/12/19 03:21] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
===== Performing a Bank Reconciliation ===== | ===== Performing a Bank Reconciliation ===== | ||
- | |||
The **Bank Reconciliation** feature of CATS lets you compare and correct the transactions in your General Ledger so that it properly matches your bank statement. | The **Bank Reconciliation** feature of CATS lets you compare and correct the transactions in your General Ledger so that it properly matches your bank statement. | ||
+ | {{entry> | ||
- | ==== Select the Statement Period ==== | + | ==== Select the Statement Period |
- | + | ||
- | To begin, select '' | + | |
+ | To begin, select **Accounting > Bank Reconciliation** from the main menu. | ||
[{{: | [{{: | ||
- | CATS will ask for a bank code and a statement month and year. Press Continue | + | CATS will ask for a bank code and a statement month and year. Press Apply after entering them to proceed. |
[{{: | [{{: | ||
CATS will pull up the information for the specified period. Below we have a statement month with no bank statement information entered. | CATS will pull up the information for the specified period. Below we have a statement month with no bank statement information entered. | ||
- | |||
[{{: | [{{: | ||
- | Fill in the numbers from your bank or credit card statement, then select | + | Fill in the numbers from your bank or credit card statement, then select |
+ | [{{: | ||
- | [{{:cats: | + | CATS updates the dialog to reflect all the items that have been entered into CATS. This includes those processed through the [[cats: |
- | CATS updates the dialog to reflect all the items that have been entered into CATS. This includes processed through the [[cats: | + | ==== Fixing Discrepancies ==== |
- | + | ||
- | [{{cats: | + | |
On this month, CATS is showing a discrepancy of $4000.00 between the bank statement and CATS. | On this month, CATS is showing a discrepancy of $4000.00 between the bank statement and CATS. | ||
+ | [{{: | ||
- | We can use the tools menu to print a list of outstanding transactions, | + | We can use the tools menu to print a list of outstanding transactions, |
- | + | ||
- | ==== Fixing Discrepancies ==== | + | |
We can add the transaction with the appropriate bank month on it, as shown below. | We can add the transaction with the appropriate bank month on it, as shown below. | ||
+ | [{{: | ||
- | [{{cats: | + | After you pick **Apply** and enter the deposit details, CATS will ask you to confirm the statement month. Pick **Yes** to continue. |
- | + | [{{:cats: | |
- | After you pick Apply and enter the deposit details, CATS will ask you to confirm the statement month. Pick Yes to continue. | + | |
- | + | ||
- | [{{cats: | + | |
This has the same effect as described in the clearing process below. | This has the same effect as described in the clearing process below. | ||
Line 47: | Line 40: | ||
Clearing a transaction in CATS means placing the bank statement year and month on it. This tells CATS to put that transaction against the totals for that month. The process of linking a transaction to a particular bank statement is usually taken care of via the import transactions tool. | Clearing a transaction in CATS means placing the bank statement year and month on it. This tells CATS to put that transaction against the totals for that month. The process of linking a transaction to a particular bank statement is usually taken care of via the import transactions tool. | ||
- | To manually clear deposits select ''Tools'' | + | To manually clear deposits select '**Tools > Clear Transactions Current > Deposit Slips** from the menu. (You can also clear **Receipts** or **Disbursements**) |
+ | [{{: | ||
- | [{{cats: | + | CATS will display a list of uncleared transactions. You can select one or more transactions at a time. In our case, we have just the single transaction we entered. Select the transaction from the list, then pick Continue. |
+ | [{{:cats: | ||
+ | |||
+ | Transactions from previous months can be cleared if using the **Clear Transactions History** menu choice. Occasionally, | ||
+ | |||
+ | Having entered and cleared the missing transaction, | ||
+ | [{{: | ||
- | CATS will display a list of uncleared transactions. You can select one or more transactions at a time. In our case, we have just the single transaction we entered. Select | + | <note important> |
+ | [{{: | ||
+ | |||
+ | ==== Printing Statements and Outstanding Listings==== | ||
+ | |||
+ | If a discrepancy is difficult to find or reconcile, or to see a printed record of transactions, you can print the Bank Statement or the Outstanding Listing. Choose **Tools > Outstanding Listing** to print a list of transactions that have not yet been cleared in CATS. | ||
+ | [{{: | ||
+ | |||
+ | CATS will give you options for how to display the transactions. Pick an order option to continue. | ||
+ | [{{: | ||
+ | |||
+ | You may print the report to a text file, preview on screen, or print to the printer. Choose an option | ||
+ | [{{: | ||
- | [{{cats: | + | Here is a sample list of transactions. Disbursements will be on the first page(s), followed by credits. |
+ | [{{:cats: | ||
- | Transactions | + | Select the printer icon from the toolbar menu to print a list that has been printed |
- | Having entered and cleared | + | The Statement List works in the same way, displaying |
- | [{{cats: | + | Once all items match the statement, the Bank Reconciliation |
- | <note important>You will need to enter the statement's ending balance in the next month' | + | {{tag>"bank reconciliation" |