Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision | ||
cats:procedures:accounting:bankrec [2014/10/01 16:35] – amanda | cats:procedures:accounting:bankrec [2016/04/08 16:05] – jen | ||
---|---|---|---|
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 and Entering Values ==== | ==== Select the Statement Period and Entering Values ==== | ||
- | To begin, select | + | To begin, select |
[{{: | [{{: | ||
CATS will ask for a bank code and a statement month and year. Press Continue after entering them to proceed. | CATS will ask for a bank code and a statement month and year. Press Continue 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 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 those processed through the [[cats: | ||
- | |||
==== Fixing Discrepancies ==== | ==== Fixing Discrepancies ==== | ||
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, |
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 48: | 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, | ||
- | 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 | + | Having entered and cleared the missing transaction, |
+ | [{{: | ||
+ | |||
+ | <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" |