Submit a ticket

Standard Report - Management Report

Updated on Follow
0 out of 0 found this helpful

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.

ManagementReport.png

 

 

 

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

Field Name

Explanation

Billing Section

 

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

 

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

Only Customers with top 5 Total Bill is included in Report

Branch

Transaction Branch

Customer Name

Rolled up to Root Customer.

Total Bill

Total Bill from Transaction Detail

Gross Profit

If @Include Burden Factor = True, Gross Profit from Transaction Burden

If @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

 

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

If AR Aging Date Type = Due Date; DSO = End Date  - Due Date

If AR Aging Date Type = Invoice Date; DSO = End Date  - Invoice Date

If AR Aging Date Type = Accounting Period Date; DSO = End Date  - Accounting Period Date

 

 

Gross Profit and Sales

[Detailed GP Calculation 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.

See https://support.avionte.com/hc/en-us/articles/211115577-WcCode-Tab-Worker-s-Compensation- to know more on how Avionte calculates 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

 

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

[Only Available in Supplier Page]

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

 

 

 

 

 

 

 

Special Logic

  • 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. We can see additional field in Supplier info page: Taxes

Have more questions? Submit a request

0 Comments


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.