Written by: MissP 363 views
This process involves five steps: client document receipt, data entry, data verification, printing/binding and client document return/consultation. Some steps have certain substeps or finer details which will be explained. Presented here is a graphical explanation of the process.

Steps
Reconciliation of the bank accounts require possession of the monthly bank statements. The period covered in the statement should match the period entered in the system. Checks, deposits and withdrawals should be compared, one to one, checking off each item as it is confirmed. Provided there is no discrepancy, the system should report a zero balance after all items are confirmed. If not, the accountant should review the bank statement and the system to see if something was not entered or confirmed correctly. This is where a good deal of the mistakes made in the Data Entry phase are discovered. But it’s also where a lot of client-level issues are found.
Analysis of cash on hand can be made by exporting the cash on hand data from the accounting system into a spreadsheet. The writer suggests separating the data into five different tabs on the spreadsheet: income, cash paid out, deposits, withdrawals and cleared transactions. The Income tab is a summary of the whole analysis. It starts with a revenue figure or “General Monthly Sales,” minus “Total Deposits,” minus “Cash Paid Out,” plus “Total Withdrawals,” plus (or minus) “Cleared Transactions Discrepancy,” plus (or minus) last month’s ending balance. This should give the ending monthly cash on hand balance. To facilitate intra-month consistency, each one of these totals should be cell-referenced from their respective tabs. The Cash Paid Out tab should list all of those transactions involving a payment of cash. These are typically operational expenses. The Deposits tab should list all of the deposits made from cash on hand to the bank account. This should be checked against the deposits total given on the bank statements. The Withdrawals tab should list all of the withdrawals made from the bank account to cash on hand. Like deposits, this should be compared to the total provided on the bank statements. The Cleared Transactions tab should include those transactions that have a corresponding “netting-out” entry for the same month. If the corresponding entry is not found, the difference must be adjusted using the “Cleared Transactions Discrepancy” line on the Income tab. These are typically transactions involving tax liabilities and their corresponding payments. The entire point of a cash on hand analysis is to provide the accountant with the ability to answer specific questions about the client’s cash flow at any given time.
Cleaning the suspense account is about using one’s judgment and communication skills to arrive at the best possible treatment of a transaction. If, after looking at all of the available documents and data, it is found that the transaction in question cannot, without a substantial departure from the truth, be placed in an appropriate account, then it is time to contact the client for further details. This should the option of last resort, however, as the client can sometimes be very busy and does not have the time to be talking about something the firm may have been able to resolve on its own with the documents and data already provided.