Excel tip: Formula to cross check ledger transactions

This is a real time saver, and I hope it's useful to someone else. If you have a typical "ledger" type spread sheet, with columns, payments in, payments out and balance - based on the image above. Perhaps this has been entered manually, or perhaps it's been OCR'd from paper, there could be errors in…

Mass Allocations

Reclassing Net Assets in QuickBooks

Free Excel Check Register @ Moneyspot.org

Excel VLOOKUP Function Examples and Troubleshoot Problems

Journal entry testing using Excel - Journal of Accountancy

match - Cross check values betwen 2 columns in Excel - Stack Overflow

Bank statement analysis: Definition and importance of bank statement analysis software - how to select one?

Excel Tutorial to Quickly Reconcile two sets of Data

Check Register Template For Excel

How to Create a Simple Checkbook Register With Microsoft Excel