Example of a simple cash-basis journal
[office src=”https://skydrive.live.com/embed?cid=DED5DA8C9025C21D&resid=DED5DA8C9025C21D%211797&authkey=AFYVov5tPK8q1sk&em=2&wdAllowInteractivity=False&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True” width=”700″ height=”346″]
The data here was downloaded directly from the bank. With a little formatting the accountant or bookkeeper can quickly develop a useful spreadsheet that can search and filter transactions, calculate totals and generally serve as a useful record for the company.
With some knowledge of advanced spreadsheet techniques (see TRAINING YOUR ACCOUNTANT), your accountant can quickly build a pivot table to summarize a year’s worth of transactions into a single journal entry.