 | Loading… |
|
|
Comparing Outstanding Items Report and Payment Analysis
Comparing Outstanding Items Report and Payment Analysis
Comparing Outstanding
Items Report and Payment Analysis
You can use two types of report for displaying outstanding items:
- Use Custom outstanding items report to see their status. It looks through all posts (see
lines of journal entry) belonging to the selected period. Post is any payment and posted receivable or payable. You should enter only end due dates, document dates and/or posting dates (dates to) using this type of report in order to find outstanding items and incorrectly closed documents and payments.
- Use Custom payment analysis by documents to see the status of outstanding items. It looks through all documents belonging to the selected period. Use it to create complex analyses of outstanding items. These analyses are based on issued documents. This is followed by subsequent payments in the later stages of the analysis.
If posts and related documents do not match trying to create an outstanding items report WITHOUT specifying date criteria, it occurs due to incorrect closing of documents or due to the fact that you posted payment whose related document has not been posted.
Trying to display the report including date restrictions, incongruities occur due to invoices that are posted with different due dates.
The distinction between both types of report can best be presented through examples.
- Issued invoice with ID of linked document 07300000024, due date (currency) April 13th, 2007, €1,000 debit
- Received payment with ID of linked document 001, due date (currency) April 16th 2007, €1,000 credit
Creating an outstanding items report using such data, the report and payment analysis differ:
1.Payment Analysis by Documents
a) Outstanding items type "Customer"
Returns information that the linked document 07300000024 has not been paid. The customer has an outstanding amount of €1,000 pending since payments without documents were not included in the report.
b) Outstanding items type "Include Overpayments"
returns information that the linked document 07300000024 has not been paid. Because you checked Include Overpayments, the report will include all payments which do not close open linked documents. That is why customer's outstanding amount is €0,00. Since the two items are not mutually closed, they both appear in the outstanding items report.
2. Custom Outstanding Items Report (by Posts)
returns information that the linked document 07300000024 has not been paid. Because all payments which do not close open linked documents are included in the report, the customer's outstanding amount is €0,00. Since the two items are not mutually closed, they both appear in the outstanding items report.
Manually closing outstanding items closes the invoice and its payment mutually. Hence both overviews give equivalent results regardless of the selected criteria.
For examples of reports see Incorrectly Closed Document.
Issued invoice with ID of linked document 07300000025 in the amount of €6,000 with maturities:
Date |
Amount Due |
Outstanding Item - Cumulative |
01.03.07
|
1,000.00 EUR
|
1,000.00 EUR |
16.03.07
|
1,000.00 EUR
|
22,000.00 EUR |
16.04.07
|
1,000.00 EUR
|
33,000.00 EUR |
16.05.07
|
1,000.00 EUR
|
44,000.00 EUR |
16.06.07
|
1,000.00 EUR
|
55,000.00 EUR |
16.07.07
|
1,000.00 EUR
|
6,000.00 EUR |
1a. Payment Analysis by Documents Including Due Dates and without Date of Balance
Enter May 1st, 2007 to May 31st, 2007 as due date. Do not enter date of balance. Since due dates are used in payment analysis by documents, it affects whether document is displayed in report or not. Leaving date of balance field empty, the displayed report contains ALL receivables of the linked document.
Due Date |
Amount Due |
Outstanding Item - Cumulative |
01.03.07
|
1,000.00 EUR
|
1,000.00 EUR |
16.03.07
|
1,000.00 EUR
|
22,000.00 EUR |
16.04.07
|
1,000.00 EUR
|
33,000.00 EUR |
16.05.07
|
1,000.00 EUR
|
44,000.00 EUR |
16.06.07
|
1,000.00 EUR
|
55,000.00 EUR |
16.07.07
|
1,000.00 EUR
|
6,000.00 EUR |
1b. Payment Analysis by Documents Including Due Dates and Date of Balance
Let us continue with the above example and enter maturity period from May 1st, 2007 to May 31st, 2007:
Let us assume that you want to find out the balance of documents on June 30th, 2007. Enter June 30th 2007 as date of balance. In contrast to the above example the list of outstanding items in this case contains ONLY receivables and closing of receivables for the linked document. Further, they are dated with due dates ON or PRIOR TO June 30th, 2007. Lines containing due dates of July 16th, 2007 are not be included in the outstanding items report.
Due Date |
Amount Due |
Outstanding Item - Cumulative |
01.03.07
|
1,000.00 EUR
|
1,000.00 EUR |
16.03.07
|
1,000.00 EUR
|
22,000.00 EUR |
16.04.07
|
1,000.00 EUR
|
33,000.00 EUR |
16.05.07
|
1,000.00 EUR
|
44,000.00 EUR |
16.06.07
|
1,000.00 EUR
|
55,000.00 EUR |
2. Custom Report - Overview of Posts Including Due Date
Enter maturity period TO May 31st, 2007. All records with due dates ON or PRIOR TO May 31st, 2007 will be included in the outstanding items report. Lines containing due dates of June 16th, 2007 and July 16th, 2007 are not included in the outstanding items report.
Due Date |
Amount Due |
Outstanding Item - Cumulative |
01.03.07
|
1,000.00 EUR
|
1,000.00 EUR |
16.03.07
|
1,000.00 EUR
|
22,000.00 EUR |
16.04.07
|
1,000.00 EUR
|
33,000.00 EUR |
16.05.07
|
1,000.00 EUR
|
44,000.00 EUR |
For examples of reports see Invoice with Different Due Dates.
Related topics
For a general description of functions see:
 | Loading… |
 | Loading… |
|
|
|