This report gives a good summary of the AR Aging As Of report and can help to quickly determine outstanding AR balances without extraneous information.
- 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.
Report Description
Shows Billing, Payroll, Top 5 Customer GP, and AR Aging summaries broken down by Branch.
This report gives a good summary of the AR Aging As Of report and can help to quickly determine outstanding AR balances without extraneous information.
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
|
|
Av. Rate |
Average Bill Rate
|
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
|
|
Av. Rate |
Average Pay Rate
|
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
|
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
|
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. |
|
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 |
