Cash Receipts Journal - Accounting Software Secrets
17690
book-template-default,single,single-book,postid-17690,bridge-core-2.6.3,qode-page-transition-enabled,ajax_fade,page_not_loaded,,qode-theme-ver-24.8,qode-theme-bridge,qode_header_in_grid,wpb-js-composer js-comp-ver-6.5.0,vc_responsive

Cash Receipts Journal

Cash Receipts Journal

<h1><a name=”_Toc40177009″><em>Creating a Cash Receipts Journal</em></a></h1>
<p> </p>
<p>A standard report in many accounting software packages is a cash receipts journal.  QuickBooks does not have a report in the format that accountants are used to working with.  The <a href=”http://www.4luvofbiz.com/kb/premium.php?cat=25&id=%3Ca%20ref=” 281100″=””>deposit detail report</a> works well for seeing the components of the deposit, but that report   does not, by default, have a total of all deposits for the period.  Below are the instructions to create a custom report that has a total of all receipts.</p>
<ol>
  <li>1.<span times=”” new=”” roman””=””>        </span>Choose Reports &gt; Custom Transaction Detail Report.</li>
  <li>2.<span times=”” new=”” roman””=””>        </span>Click on the Modify Report button.</li>
  <li>3.<span times=”” new=”” roman””=””>        </span>On the Display tab, change the date range to the appropriate period and the sort by to Num.  </li>
  <li>4.<span times=”” new=”” roman””=””>        </span>Scroll   to the bottom of the columns list and add a check mark next to debit,   and remove the check marks next to account, class, amount and balance.</li>
  <li>5.<span times=”” new=”” roman””=””>        </span>On the Filters tab, choose the appropriate bank account.  You will notice the date range as the same as number 3 above</li>
  <li>6.<span times=”” new=”” roman””=””>        </span>Next, click on the transaction type, and from the pull down list, choose selected transaction types.  This creates a pop out box of all the transaction types.  Place a check mark next to the cash receipt types (i.e. deposits, sales receipt, payment, and possibly transfers)</li>
  <li>7.<span times=”” new=”” roman””=””>        </span>Choose the Header/Footer Tab and change the report title.</li>
  <li>8.<span times=”” new=”” roman””=””>        </span>Click on OK.</li>
  <li> </li>
</ol>
<p>TIP: To create a <a href=”http://www.4luvofbiz.com/kb/premium.php?cat=25&id=282200″>cash disbursements journal</a>,   follow the same steps as above except choose credit in step 4 and bill   payments, checks, sales tax payments, paychecks, payroll liability   checks, and possibly transfers in step 6.</p>
<p> </p>
<p>TIP: To create a report that will agree to <a href=”http://www.4luvofbiz.com/kb/premium.php?cat=25&id=293400″>batch totals</a> when completing data entry procedures, filter for the edit/modify date that the data entry was completed.  Depending   on the review procedures, it is also possible to change the display tab   to sort by account and the filter tab to include all accounts.  This   will provide a report that shows the total for the cash account, while   also showing the totals for the amounts coded to the other general   ledger accounts as part of the transaction. </p>
<p> </p>
<p>TIP:   If a single report that includes both a cash receipts and a cash   disbursements journal are desired, it is possible to change step 4 to be   both debit and credit (i.e. a separate column for receipts and   disbursements) and all transactions for step 6.</p>
<h1> </h1>
<h2>More information on this topic</h2>
<p><a href=”http://www.4luvofbiz.com/kb/premium.php?cat=25&id=1281″>Cash Receipts Journal</a></p>