Standard Report - Management Report

Updated August 29, 2024 19:36

Purpose: This report provides a summary of AR (Accounts Receivable) Aging, Billing, Payroll, and Gross Profit data, segmented by Branch, helping businesses quickly identify outstanding AR balances without unnecessary details.

The report page is separated per Branch.
There is one extra page for Supplier that will be added in the report when user selects ‘True’ in Show Supplier Info parameter.

Why It Matters: Effective AR management is key to maintaining cash flow and understanding financial health. This report aids in assessing customer payments, outstanding balances, and payroll costs, essential for financial planning.

Efficiency Drivers:

Segmented View: Breakdown by Branch offers targeted insights for better decision-making.
Customizable Parameters: Options to include burden factors, supplier info, and select AR Aging Date Type enhance report relevance.

Parameters

Parameter Name	Options	Explanation
Branch	All available branches
Accounting Period Start Date
Accounting Period End Date
Include Burden Factor	True/False	IF Include Burden Factor = True, Pull Gross Profit, Agency Cost, Employer Taxes, Worker Comp Cost and Burden from Transaction Detail If Include Burden Factor = False, Pull Gross Profit, Agency Cost, Employer Taxes, Worker Comp Cost and Burden from Transaction Burden
Show Supplier Info	True/False	Choose to view Supplier info or not.
AR Aging Date Type	Due Date, Invoice Date, Accounting Period Date	Filter for Due Date, Invoice Date or Accounting Period Date of Invoice. This Date type is only applicable for AR Aging Section

Report Fields

Billing

Field Name	Explanation
Branch	Transaction Branch
Type	Pay code from Transaction
Total Bill	Sum of Item Bill from TransactionEntryItem
Bill Amount	Sum of Item Bill from TransactionEntryItem for non-deduction pay codes
Units	Sum of Bill Units from Transaction [Sum of Item Bill from Transaction Entry Item]
Av. Unit	Average Bill Units Average Bill Units = Total Bill / No of Customers
Av. Rate	Average Bill Rate Average Bill Rate = Total Bill /Total Bill Unit

Payroll

Field Name	Explanation
Branch	Transaction Branch
Type	Pay code from Transaction
Total Pay	Sum of Item Pay from TransactionEntryItem
Gross Wages	Sum of Item Pay from TransactionEntryItem for non-deduction pay codes
Units	Sum of Pay Units from Transaction [Sum of Item Pay from Transaction Entry Item]
Av. Unit	Average Pay Units Average Pay Units = Total Pay / No of Employees
Av. Rate	Average Pay Rate Average Pay Rate = Total Pay / Total Pay Unit

Top 5 Customers

Field Name	Explanation
Branch	Transaction Branch
Customer Name	Rolled up to Root Customer.
Total Bill	Total Bill from Transaction Detail
Gross Profit	@Include Burden Factor = True, Gross Profit from Transaction Burden @Include Burden Factor = False, Gross Profit from Transaction Detail
GP%	Gross Profit divided by (BillAmount + GPAdjBill – DiscountAmount)
% of Sales	Proportion of Total Bill composition of Customer to Total Bill of Supplier = (Total Bill of Customer)/(Total Bill of Supplier)

AR Aging

Field Name	Explanation
Branch	Invoice Branch
Total Due	Total Due/Open Balance Amount for Branch
Current	Total Current Open Balance; Current: (DSO < 0)
0-30	Total Open Balance from invoices with DSO between 0 to 30
31-60	Total Open Balance from invoices with DSO between 31 to 60
61-90	Total Open Balance from invoices with DSO between 61 to 90
>90	Total Open Balance from invoices with DSO Over 90
#Note	DSO is calculated on basis of AR Aging Date Type parameter AR Aging Date Type = Due Date; DSO = End Date - Due Date AR Aging Date Type = Invoice Date; DSO = End Date - Invoice Date AR Aging Date Type = Accounting Period Date; DSO = End Date - Accounting Period Date

Gross Profit and Sales

Field Name	Explanation
Branch	Transaction Branch
Gross Wages	Sum of Item Pay from TransactionEntryItem for non-deduction pay codes
GP Adj Pay	Sum of Item Pay for Transaction types that is nontaxable and has property GPCalculation set to True.
GP Adj Cost	Sum of Item Cost for Transaction types that is nontaxable and has property GPCalculation set to True.
Agency Cost	Sum of Item pay is transaction is linked to Agency or Non W2 Employee (Sub contractors)
Employer Taxes	Sum of all Employer Taxes.
W.C.	Sum of Worker Comp Cost. Calculating Worker Comp Costs
Burden	Sum of Additional Burden, if used (Admin tools >> Burden)
Employer Contribution	Sum of all Employer Contribution
Payroll Cost	(GrossWages + AgencyCost + EmployerTaxes + WorkerComp + GPAdjPay + GPAdjCost + Burden)
Non GP Adj Bill	Sum of Item Bill for Transaction types that is nontaxable and has property GPCalculation set to False.
Non GP Adj Pay	Sum of Item Pay for Transaction types that is nontaxable and has property GPCalculation set to False.
Non GP Adj Cost	Sum of Item Cost for Transaction types that is nontaxable and has property GPCalculation set to False.
DH Fee	Sum of Item Bill for Transaction Type that is under Category “DirectHire”
Bill Amount	Sum of Item Bill of all Transaction type which is taxable i.e. Is Adjustment = 0
GP Adj Bill	Sum of Item Bill for Transaction types that is nontaxable and has property GPCalculation set to True.
Discount Amount	Discount Amount, if used.
Billed Amount	(Bill Amount + GP Adj Bill + Discount Amount)
Gross Profit	(BillAmount + GPAdjBill – DiscountAmount) – (GrossWages + AgencyCost + EmployerTaxes + WorkerComp + GPAdjPay + GPAdjCost + Burden)

Other Numbers of Interest

Field Name	Explanation
Branch Name	Branch Name
# Emp Paid	Number of Employees from paid Transactions with Accounting Period Date within the Date Range
# Emp Billed	Number of Employees from Billed Transactions with Accounting Period Date within the Date Range
# Checks	Number of checks in range for Branch
# Invoices	Number of Invoices in range for Branch
# of Customers	Number of Customers from Transactions with Accounting Period Date within the Date Range
# of New Customers	Number of New Customers who have been billed for the first time in selected Date Range
Total Billed Hours	Total Hours billed for Branch [Sum of Bill Units for Transaction Types]
# Direct Deposits	Number of Direct Deposit checks generated (IsDirectDeposit = 1)
# Live Checks	Number of Live checks generated (IsDirectDeposit = 0)
# Direct Hires	Number of DH Orders from Transactions with Accounting Period Date within the Date Range
# Assignments	Numbers of Assignments from Transactions with Accounting Period Date within the Date Range
# Orders	Number of Staffing Orders from Transactions with Accounting Period Date within the Date Range
# New Hires	No of Employees with first ever check in selected Date Range
Total Paid Hours	Total Hours Paid for Branch [Sum of Pay Units for Transaction Types]

Taxes

Note: The Tax section is only visible when Show Supplier Info is True. The Taxes only show on the Supplier/Employer Total Page.

Field Name	Explanation
Staffing Company	Staffing Company Name
Tax Name	Tax Name from Tax Master
Taxable Gross	Total Taxable Gross (Total Wages in which actual Tax is calculated) from PaymentCheckTax
Tax Amount	Total Tax Amount from PaymentCheckTax

Actionable Insights:

Identify Top 5 Customers by Gross Profit: Helps in understanding customer contribution to revenue.
Monitor AR Aging: Quickly spot overdue payments and manage collection efforts.

Utilizing the Management Summary Report enables informed decision-making, streamlined financial operations, and effective AR management, directly impacting the company's financial stability and growth.