Software > Box 3 > Accounts Receivable (Dbl Entry)

Template:  ​​ZAP_b3_AccountsReceivable_dblEntryDemo   

Technical Details

Approximate # of Active Worksheets: 3
Approximate. # of silent worksheets: 1 
​ArrayFormulas: 6
Bound Script Project used? No
Unbound Script Project connected? No

For Small Businesses, Accounts Receivable are often kept 1) on a piece of paper like a bar tab 2) in a simple spreadsheet like a bar tab or 3) in an invoicing module where invoices were sent out (when they are paid they are just checked off the list).  

In such businesses, the "Accounts Receivable" Account does not exist in the Chart of Accounts.  The Accounts Recievable are all just a part of the cash inflow process and nothing is relevant for Tax Accounting until the money hits the bank.

Thus, the entire idea of Accounts Receivable is NOT included as part of the Double Entry, Tax Accounting Process.   

​In such businesses, when the money is collected, the sale is considered to have been made and not prior (not when it transacted).

​HOWEVER. businesses doing over $5 million in sales are required to include Accounts Receivable as an Asset.  Often times the easiest way to do that is to keep a Journal in a fully separate module and then just manually add them to the Balance Sheet for reporting. 

HOWEVER, some folks may want or need a Double Entry Accounting style A/R module to work in parallel with or integrate into your primary ZAP Bookkeeping module. If so, this is for you. 

This workbook contains a Journal Worksheet identical to the checking, credit card and Expenses Paid Via Journals in the primary module and it contains samples of the equations needed to create relevant reporting. Technically these could be added back to the primary bookkeeping module and integrated into the transaction aggregator (and thus the General Journal) with an addition to the master union in the Transaction Aggregator.