Cash Spend Receivables/Payables

Overview

The report is a breakdown of the Payables and Receivables transactions pulled from the Cash Spend Report.

To view the Report, Navigate to Reports > Cash Spend Payables and Receivables Breakdown. 

Functionality to drill down to the payment transaction has been added for easy navigation.

Filters

• Date selection - Period date.

• Only Payments allocated to invoices are displayed.

• Payments against opening balance invoices are ignored. (i.e. Has a missing credit or debit account).

Tech Notes 

• Paid % - Calculated as the percentage of the invoice paid by the payment transaction. 

• Contra Account - Shows the value of the contra accounts on the invoice.

• Paid Amount - Is the % Paid of the Contra Amount. 

• Payment Trans is the linked used to compare the Cash Spend Report

Fields

• Type (Inflows/Outflows)

• Payment Transaction (CR or SP)

• Payment Date.

• Account Category (Receivables /Payables)

• Company 

• Contra Account 

• Invoice Paid (CI/SI) 

• Paid % 

• Contra Amount

• Paid Amount