Create year-end reports

The Accounting Summary Report and the Inventory Valuation Summary Report are required for tax purposes. The results occur in real time, which means that they are only valid on the precise time and day that they were produced. If you miss the calendar year-end or fiscal year-end deadline for creating the reports, contact Paladin Customer Support to retrieve the data. It is also beneficial to create a Period Comparative Revenue Report.

This article provides instruction and information on the following:

• How to create the Accounting Summary Report (required for tax purposes)
• How to create the Inventory Valuation Summary Report (required for tax purposes)
• How to create the Period Comparative Revenue Report (optional)

How to create the Accounting Summary Report

1. In Paladin, on the top ribbon, select the Reports module.
2. In the Report Area pane, select Accounts Receivable >  Accounting Reports.
3. In the Reports List pane, select Accounting Summary Report.
4. In the Choose Report pane, click F12 Next.
5. In the Sorting Options pane, click F12 Run Report.

A PDF file of the report opens.

Back to Top

How to create an Inventory Valuation Summary report

You can see the total value of inventory filtered by part number ranges, departments, suppliers, classes, subclasses, or locations. The report includes the following information by department:

• • • Number of items
    • Stock value
    • Retail value
    • YTD value
    • YTD profit
    • Margin on sales
    • Gross margin return on investment (GMROI) 

1. In Paladin, on the top ribbon, select the Reports module.
2. In the Report Area pane, select Inventory > General.
3. In the Report List pane, select Inventory Valuation Summary.
4. In the Choose Report pane, click F12 Next.
5. In the Inventory Valuation Summary window, in the Report Settings pane, enter the report parameters.
6. In the Additional Settings pane, you can choose to check Include On-Hold Inventory.
7. In the Sorting Options pane, click F12 Run Report.

A PDF file of the report opens.

Back to Top

How to create the Period Comparative Revenue Report

1. In Paladin, on the top ribbon, select the Reports module.
2. In the Report Area pane, select Sales Analysis > Revenue.
3. In the Report List pane, select Period Comparative Revenue.
4. In the Choose Report pane, click F12 Next.
5. In the Period Comparative Revenue window, in the Report Settings pane, in the Dates row, select January 1 and the tax year in the first calendar list, then select December 31 and the tax year in the second calendar list.
6. Optional: To create the report for one terminal, in the Terminal row, select the terminal in both lists.
7. Optional: To create the report for one employee, in the Employee row, elect the employee in both lists.
8. Optional: Check Include prior year comparative totals?
9. Optional: Check Expense payment discount?
10. Optional: Check Export to Excel?
11. Optional: Check Exclude Tax from Gross Profit?
12. In the Compare last year row, select By Date or By Business Day.
13. In the Sorting Options pane, click F12 Run Report.

A PDF file of the report opens.

Back to Top

To learn more, view the following webinar: Year-end Reports: Why You Need Them, How to Make Them Automatic