Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I formulate a reconciliation?
I am trying to wrap my head around doing account reconciliations more
effectively. The source data has been exported from an accounting program. Now, I need a quick way of producing a formula that will assist in the matching process. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I formulate a reconciliation?
You need to be little more specific about what you your goal is and what
you are trying to achieve, Regards, Alan. "Gorilla Show" <Gorilla wrote in message ... I am trying to wrap my head around doing account reconciliations more effectively. The source data has been exported from an accounting program. Now, I need a quick way of producing a formula that will assist in the matching process. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I formulate a reconciliation?
My first question is why doesn't the accounting software do the
reconciliation. That would be much more efficient. However, if the only choice is to do it in Excel, you will need to sum the outstanding checks and deposits, then deduct this from the register balance. This should give you the bank balance. First, create a column where it can be indicated whether the transaction has cleared the bank (like 'R'). Then your bank balance formula is: =RegisterBalance + Sumif (checks not 'r') - sumif(deposits not 'r') Hope this helps, Fred. "Gorilla Show" <Gorilla wrote in message ... I am trying to wrap my head around doing account reconciliations more effectively. The source data has been exported from an accounting program. Now, I need a quick way of producing a formula that will assist in the matching process. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reconciliation of numbers | Excel Discussion (Misc queries) | |||
reconciliation in different currencies | Excel Discussion (Misc queries) | |||
Macro for Bank Reconciliation | Excel Discussion (Misc queries) | |||
Bank Reconciliation | Excel Discussion (Misc queries) | |||
Stock Reconciliation | Excel Worksheet Functions |