What a Simple Cash-basis Journal Might Look Like

Example of a simple cash-basis journal

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.