|
The Windows versions of the custom reports
are compressed into .zip files, which should be automatically decompressed
by your browser (if not, call your internet export to configure your browser
for WinZip). When
a custom report is decompressed in Windows, it will have the file extension
.AHR, which means "ad hoc report." The Macintosh versions of custom reports
are compressed into a .hqx (Binhex) file, which should be automated decoded
by your browser (if not, call your Internet expert and ask them to configure
your browser with Stuffit
Expander).
Looking for tips? Click
here
for great tips, shortcuts, and suggestions for better
custom reports.
Need help finding the right fields for a custom report?
The data dictionary
is a comprehensive listing of the files and fields used in Clients &
Profits, including what each field is used for.
Macintosh | Windows
A/R
Past Due Invoices | ARPAST1.AHR
- Shows unpaid invoices
sub-totaled by client. The query uses two calculated
fields to calculate each invoice's unpaid balance
(less any applicable discounts) and the number of days
each invoice is past due (using the pay date). The
report uses a lookup field for the client name.
Advanced Billing | ADVBILL.AHR
- This report shows shows
jobs that have advanced billings.
Client
Time by Staff | CLIENT_TIME.AHR
- The Client Time report
lists time entries by client, including date, job
number, accounting period, cost amount, and billable
amount. Time hours are shown in detail, and is
sub-totaled by client.
Clients
by Division | CLDIV.AHR
- This report lists clients
grouped by division. Every client can belong to one
division, which is the sub-totalling field C_DIVISION.
The division is also a client number. Divisions are
listed alphabetically. Clients appear alphabetically
by account code within each division.
Commissions
| COMMIS.AHR
- This modified sales report
compiles client invoices for a range of dates to
calculate AE sales commissions.
Comparative
Financials | CMPFIN1.AHR
- This report compare this
period-to-totals with the year-to-date totals for this
year and last year. Each account class (i.e., asset,
liability, income, etc.) displays its accounts and
their balances, along with a total for each class. The
report doesn't use the standard template because of
the way in which it sorts.
Division
Billings | DIVBILL.AHR
- This report shows billings
by client, sub-totaled by the client's division.
Fixed
Asset Purchases | FXPURCH.AHR
- This report shows purchases
posted into the General Ledger. The report is based on
journal entries added for one or more accounts, using
the account number field JE_AC_NUM. In the query
you'll enter the range of accounts you use for
recording fixed asset purchases. Entries are
sub-totaled by account name (AC_NAME), then sorted by
date (JE_DATE). Since the description you enter onto
the purchases can be lengthy, the description field
(JE_DESC) appears in the Positioning section. This
section lets long fields expand as needed.
G/L
Budget vs. Actual | GLBUDA1.AHR
- This report resembles a
trial balance. It shows all G/L accounts sub-totaled
by account class (assets, liabilities, equity, etc.).
For each account you'll see a budget amount, actual
account, and the percentage of budget. Both the budget
field (BUDGET) and actual field (ACTUAL) are
calculated. You can change the calculation to show one
period, a quarter, or any other number of periods.
G/L
Budget w/Variance | GLBUDV1.AHR
- This report resembles a
trial balance. It shows all G/L accounts sub-totaled
by account class (assets, liabilities, equity, etc.).
For each account you'll see a budget amount, actual
account, and the percentage of budget. Both the budget
field (BUDGET) and actual field (ACTUAL) are
calculated. The variance field (VARIANCE) is simply
the different between the account's budget amount and
actual amount. You can change the calculation to show
one period, a quarter, or any other number of periods.
G/L
Expenses >10% Budget | GLEX10B.AHR
- This report selects expense
accounts from the General Ledger (i.e., those accounts
with an AC_CLASS >= 5 or <= 6). The calculated
field PERC_OVER_BUDGER determines whether or not an
accounts is included on the report. The percentage can
be changed (it is now 10%) to select more or less
accounts (for example, to see accounts over-budget by
25%).
G/L
Q1-Q4 Totals | GLQTR14.AHR
- This report calculates the
quarterly totals for every account in the General
Ledger. The four quarterly totals are calculated
fields (i.e., Q1, Q2, Q3, Q4). The calculation for Q1,
for example, is AC1+AC2+AC3. These calculations assume
the accounting system works on a calendar-year basis.
To properly show your fiscal year, change the
quarterly calculations using the appropriate fields.
Job
Costs On-hold | CSTHOLD.AHR
- This report shows unbilled
job costs in detail, grouped by task code. Only tasks
with status as "on-hold" (i.e., COST_STATUS = On-Hold)
as selected by the query.
Job
Counts | JOB_CNTS.AHR
- This report shows the
number of jobs opened for each client. You can modify
the query to select only jobs opened by a single AE,
or a range of start dates, for one project, or some
other criteria. It's a handy statistical report for
analyzing how busy you've been.
Job
List by AE | JOBAE.AHR
- This report lists jobs by
account executive. Jobs are selected by production
status; you can enter any range in the Query window to
show more or fewer jobs. A separate page prints for
each AE/Team because the J_AE_TEAM field has the "New
Page" sort attribute. The status description appears
using a lookup on the STATUS_NUM field. It's easy to
add new fields to this report (especially the jobs
user-defined fields).
Job
Log w/Schedule | JOBLGSC.ZIP
- This report lists
unfinished job tasks (i.e., tasks where
X_DUE_DATE>0) by job number.
Job
Summary | JOBSUM.AHR
- This report resembles the
standard job summary that's printed from the Job
Ticket window. Each job ticket is printed on a
separate page. The job's tasks are sub-totalled by
group (X_GROUP) and sorted numerically (X_SORT).
Staff
Time (Budget vs. Actual) | STAFTM1.AHR
- This report compares the
monthly budget and actual time totals for staff
members. These totals are updated automatically from
time sheets, representing the hours entered for any
given period. The report is set up to show totals for
period 1, but this can be changed. The two
fields--CUR_ACT and CUR_BUD--are calculated fields.
The calculation determines which monthly totals will
be compared. You can enter one period (e.g., S_1) or
many periods. For example, to compare a quarter's
time, enter the calculation as S_1+S_2+S_3.
Unbilled
Job Costs | UNBLCST.AHR
- This report shows unbilled
job costs in detail, grouped by task code. Only tasks
with status as "unbilled" (i.e., COST_STATUS =
Unbilled) as selected by the query. If you use a
custom cost status, you can change the query to select
those costs. To select costs from different statuses,
change the query like this: =Unbilled, =On-Hold,
=Killed.
Unbilled
Time | UNBLTM.AHR
- This report shows unbilled
time entries in detail, grouped by job number. Only
costs with COST_KIND=1 and a billing status of
"Unbilled" will be selected. If you use a custom cost
status, you can change the query to select those
costs. To select costs from different statuses, change
the query like this: =Unbilled, =On-Hold, =Killed.
Vendor
Labels | VLABL1.AHR
- These vendor labels can be
customized by adding and removing fields.
YTD
G/L Balances | GLYTD.AHR
- This report creates a
export file of the monthly account balances for every
G/L account. The export format is chosen when the
report is printed.
|
