Purpose

This article outlines the information for the Invoice Aging Report for 365 Catering (Spoonfed) in the Invoice Module.
 

Process

The Invoice Aging report is a downloadable option in the Invoice Module. Users with the appropriate permissions can access this report, which includes additional columns such as invoice due date, number of days overdue, invoice amount, and invoice created by user. 

The aging report will allow users to filter invoices based on specific aging criteria, making it easier to track overdue invoices and payments. This report will be accessible from the existing invoice report interface, with a new filter added to allow users to select and generate an aging report.

A Sort by option is included to give the user the ability to sort the Invoice Aging reports by Invoice Number, Invoice Date, or Most Overdue fields. Most Overdue is a change to the Invoice Due field to express filtering by Last 30 days, Last 60 days or Last 90 days.

The report when pulled will be exported to an Excel file and will include the additional columns and information depending on the Invoice format that has been previously set inside the system.

Pulling the Report

1. Log into Spoonfed.
    
2. Access Invoice Module.
    
3. Click into Invoices under the dropdown.
    
4. Set the date range desired.
    
5. Select any additional information necessary to filter by: invoice number, order number, payment type, customer, etc.
    
6. Click Search to locate invoices matching the filter criteria.
    
7. Select the checkbox for any specific invoices that are going to be included in the report. Each invoice will have its own row in the exported report. 
    
8. Click Export Invoice Aging Report.

Report Information

The generic included Invoice Aging report will have several columns representing various data points.

• Transaction Type: Either Sales Invoice (SI) or Credit notes against invoices (SC).
   
• Account Ref: A reference code which is Site specific.
   
• Customer Name: the name of the customer that is receiving the invoice.
   
• Nominal Code: Nominal codes are account specific cost centers.
   
• Transaction Date: Date invoice was created.
   
• Invoice Number: The number assigned to the invoice.
   
• Type:  The type of order origin. Online order flow 1 or online order flow 2.
   
• Net Amount: Amount excluding taxes.
   
• VAT Rate: Tax rate.
   
• Tax Amount: Total tax amount.
   
• Gross Total Amount: Total invoice amount including tax.
   
• Due Date: The date the payment for  the current invoice is due.
   
• Overdue By (Days): How many days the amount due column is overdue by in days.
   
• Amount Due: The amount due by the due date on the invoice.
   
• Amount Paid: Any amount paid towards the Amount Due balance.
   

Additional Columns

These will be displayed if the settings are turned on in Spoonfed for the location generic invoice export.

• Site Name: The site name as it appears in Spoonfed.
   
• Site Code: The site code assigned to the site.