Custom formats field descriptions
Descriptions of selected fields in the
Custom Formats
screen in the Fields
pane. Custom Formula
Includes any custom formulas you have created and saved on any report that's based on the same standard report.
Report
Date — Items from the
Selection
tab of the Report Options
on the Print Reports
screen.Group — Items from the
Layout
tab of the Report Options
on the Print Reports
screen.Client
24 Period History
Fields used on the Billing Worksheet’s 24-period
History
section: Adjusted
, Collected
, Invoiced
, Produced
. For each field, the following options are available:
- First period— Use this field in the 1st column.
- First subtotal— This is the subtotal of periods 0 – 11.
- Inner Period— Will be used for periods 1 – 23. You need to edit the number in ( ) to be the appropriate period number for the column you are adding.
- Last Subtotal— This is the subtotal of periods 11 – 23.
Accounts Receivable/Activity
- All Adjustments— Total of all A/R Activity that is Adjustments (CM, DM, WO, NSF, CCR) for the reports detail range
- All Collections— Total of all A/R Activity that is considered Collections (CA, CHK, CC)
- All Credits— Total of all A/R Activity that is Credits (CA, CHK, CC, CM, WO)
- All Debits— Total of all A/R Activity that is Debits (NSF, DM, CCR)
- All Receipts— Total of all A/R Activity that is Receipts (CA, CHK, CC)
- Cash— Total of all A/R Activity that is cash.
- Credit Card— Total of all A/R Activity that is credit card.
- Credit Card Return— Total of all A/R Activity that is credit card return.
- Credit Memo— Total of all A/R Activity that is credit memo.
- Debit Memo— Total of all A/R Activity that is debit memo.
- Invoice— Total of all A/R Activity that is invoice.
- Non-Sufficient Fund— Total of all A/R Activity that is non-sufficient funds.
- Service Charge— Total of all A/R Activity that is service charge.
- Write Off— Total of all A/R Activity that is write-off.
Aging
These fields are used on the A/R Summary, the Billing Worksheet, and the Period Reconciliation.
- Ending Balance
- First Period
- Inner Period— use this formula for all aging columns but the 1st, last, and ending balance. You need to replace the number in the ( ) to be the appropriate number of the column you are placing it in.
- Last Period
Collection
These fields are used on the Collection Summary report.
- Applied Count— The total number of applications on CA, CHK & CC entries for the client for the detail range of the report
- Applied Debit Memo— Amount that is applied to debit memo.
- Applied Invoice Amount— Amount that is applied to invoices.
- Applied Service Charge Amount— Amount that is applied to service charges.
- Collected Day count— Number of days between invoice/dm/s/c date and date of CA, CC, CHK that is applied to it.
- Collected Amount— Total collected amount.
- Unapplied amount— Total amount left unapplied.
Last A/R Entry Amount
This formula will pull the last A/R entry amount (regardless of type). If you want the last invoice entry amount, edit the formula to change ALL to INV, or to REC for receipt.
Last A/R Entry Date
This formula will pull the last A/R entry date (regardless of type). If you want the last invoice entry date, edit the formula to change ALL to INV, or to REC for receipt.
Service Charge Past Due
— The amount the client is past due that will cause a service charge to calculate.Assess Service Charge
— Returns true or false — whether the client is set to assess service charges or not.Associate Staff
— All staff fields for the staff member specified as the client’s associate.WIP
— Used on Period Reconciliation and Client Investment Analysis reports.Activity
- Adjusted— Total billing adjustments
- Adjusted Expense Credit— Expenses Write Down
- Adjusted Expense Debit— Expenses Write Up
- Adjusted Time Credit— Time Write Down
- Adjusted Time Debit— Time Write Up
- Aged Billed Expense— Expense entries dated prior to report detail range but billed in detail range
- Aged Billed Time— Time entries dated prior to report detail range but billed in detail range
- Billed— Total WIP amount (std) Billed in detail range
- Current Billed Expense— Expense entries dated within report detail range and billed in detail range
- Current Billed Time— Time entries dated within report detail range and billed in detail range
- Discount
- Standard Billed— Time & Exp Billed (std)
- Standard Billed Expense— Expenses Billed (std)
- Standard Time Expense— Time Billed (std)
Production and Billing Posted
A/R Entry
- Liveamounts are independent of posted state.
- Open= unapplied
- Closed= applied
- Live closed amount- sum of the applied amount where applied date is less than report ’to’ date
- Live open amount- amount - live closed amount, where the entry date is less than report ’to’ date
- Normal amount= amount * normal sign
- Normal Posted Closed Amount= posted closed amount * normal sign
- Normal Posted Open Amount= posted open amount * normal sign
- Normal sign= 1.00 for debit items, -1.00 for credit items
- Posted open amount= posted amount - live closed amount, where the entry date is less than the report ’to’ date
Time/Expense Entry
- Liveamounts are independent of posted state
- Open= unbilled
- Closed= billed
- Live closed amount= bill_amount - adjustment, where invoice date is < report ’to’ date
- Live open amount= amount - live_closed_amount, where entry date is < report ’to’ date
- Period closed Amount= posted bill_amount - adjustment where invoice date is within the report date range
- Period open Amount= amount - period closed amount, where invoice date is within the report date range
- Posted Closed amount= posted bill_amount - adjustment, where invoice date is < report ’to’ date
- Posted Open amount- posted amount - posted_closed_amount, where entry date is < report ’to’ date