Pracsoft User Guide
Receipt Reconciliation List Report

SUMMARY:

This report lists full details of receipt item (for example: cheques, credit card vouchers and so forth), receipted within the period between the 'From:' and 'To:' dates specified below.

Note: this report can be a handy reference when you are trying to find dishonoured cheque details.

REPORT OUTPUT:

For each receipt item, the report details:

o      Bank Account: The bank account into which the payment item was deposited;

o      Date Receipted: The date on which the receipt item was entered into Pracsoft;

o      Receipt No:-The ID of the receipt within which the receipt item was entered;

o      Payment Type: The receipt item's payment type, eg Cash, Cheque, and so forth;

o      Drawer: The payer;

o      Amount: The dollar amount of the receipt item could be exclusive or inclusive of GST. If the GST column value is not zero, the amount is inclusive of GST; and

o      GST: The dollar amount of GST that was included in the receipt item.

Totals are provided for each bank account and for the Practice as a whole.

DATE SELECTION:

It is recommended that you use Report Date as the Date Selection, as this is a value that cannot be modified, ensuring integrity of the report.  That is, if you print the report for a given date range today, and then print it again in twelve months' time, for the same date range, then the two versions of the report will be identical, no matter what reversals may be applied to the receipt in future reporting periods.  In terms of this report, the term 'Report Date' refers to the date of entry of the receipt.

ADDITIONAL OPTIONS:

The Additional tab, below, includes a number of other options:

o      Include Adjustments: this option is checked by default, to include adjustment records in the report output.  If you prefer to exclude adjustments, you can click the box to uncheck it.

o      Item No(s): this option allows you to enter a specific item number to base the report on.  If you enter an item number, then the report will only show you allocations that have been made to that item.  If you wish to specify multiple item numbers, you must separate them with commas.

o       Institution: this option is disabled for this report.

To Reconcile the Report

Columns on this Report

Reconcile Against Report Columns

Receipt Reconciliation List Report

  • Totals for each Practitioner (Amount Paid and GST Paid) and Grand Totals

Detailed Receipt Allocation Report

  • Totals for each Practitioner (Amount and GST) and the Grand Totals for Practice

Receipt Reconciliation List Report

  • Grand Total - Total Amount

  • Grand Total – Total GST

Receipts by Item no Report

  • Grand Total of Fees

  • Grand Total of GST

Receipt Reconciliation List Report

  • Grand total – total amount/total GST

Single Line Summary of Receipts

  • Grand Total of Fees/GST

Receipt Reconciliation List Report

  • Grand Total of Receipts + GST

Transaction Summary Report

  • Total Receipts

Receipt Reconciliation List Report

  • Grand Total of Receipts

  • Grand total of GST

GST Summary of Receipts by Practitioner

  • Total Receipts

  • Total GST

 

 

To Generate a Receipt Reconciliation List Report

1.      Select Reports > All Reports. The Pracsoft Reports window appears.

2.      Within the Report Type section, select Receipts.

3.      Within the Report Name section, select Receipt Reconciliation List.

 

4.      Select the Common tab:

o      Enter a Date Range for the report

o      Via the Date Selection drop-down menu, indicate in which order you wish the results displayed.

o      Indicate which practitioner/s and location/s you wish to limit the report to.

 

5.      Select the Additional tab:

o      If you wish to base the report on specific item numbers, enter them here, separating each with a comma.

 

6.      Click Print when you are ready to proceed.