Cash Received Analysis report
Posted by Cameron Telfer, Last modified by Ngatokorua Elikana on 24 February 2018 10:41 AM

This report is accessed via Reports, then Accounting. This report shows payments that have been received (as well as Refunds & Returns) in a set period and provides details of the Customer the payments relates to and how those payments have been applied against the charges for that Customer based on Storman Matching. 

Note: selecting the "Use Date Banked" option means that only payments with date banked that fall within the period set will appear on the report. For instance in the example above if a payment was made on the 28/2/18 but it was not yet banked until the 1/3/18 it would not show up on the report for shown above, yet a payment that was made in 31/1/8 but banked on 1/2/18 would appear on the report.

The report is sorted by transaction date and apart form the Columns for the Total Payment amount (under Collected) and tax there are 8 columns which show the split of the various charge analysis codes. These columns are determined by the sort order of the Charge Analysis Codes under Maintenance -> Analysis Codes. Sort orders 1 to 7 have their own while sort orders 8-45 are all grouped under the "Other" Column.

The column headers will be the first instance of the sort order numbers 1-7.It is possible that you have several analysis codes with the same sort order, for example you may have several different types of cardboard boxes, each with a sort order of 5. The column header for the cardboard boxes will be the name of the first one in that list, unless you tick the Header on Report Column tick box on the analysis code that you want to appear as the report column header.

Hint: This report is intended for use only with the Cash accounting method.

(0 vote(s))
Not helpful

Comments (0)