|
% of Bad Debt Chart
|
Compares group of GL
accounts considered for returned checks against a group of income
accounts to determine a bad debt percentage for a month then displays
each month on a YTD chart. One chart being displayed for each reporting
entity. This report is based on a specific COA and COA structure and
would require considerable modification. |
2002 |
|
6 Mo. Stock Movement Report
|
This report bases it's information on
the current accounting period. It shows Location, Item Type, Item ID,
Desc., Current Qty on Hand, avg.Cost, Current Value, Last IN Date, Last
OUT Date, IN and OUT Quantities for each of the last 6 months, Beginning
Qty on Hand, Avg.Cost and Value. |
2005 |
|
Active Job Pre-bill Worksheet
|
For an entered range
of jobs, this report finds all unbilled time and expense tickets and
then lists; Ticket Date, Employee Name; Task; rate; hrs worked; amount;
billable hrs; and ticket status. A header area for each job includes
summary information about the job and customer. |
2005 |
|
Active Job Pre-bill Worksheet
|
For ALL jobs, this report finds all
unbilled time and expense tickets and then lists; Ticket Date, Employee
Name; Task; rate; hrs worked; amount; billable hrs; and ticket status. A
header area for each job includes summary information about the job and
customer. |
2005 |
|
Active Job Pre-bill Worksheet
|
For an entered range
of jobs, this report finds all unbilled time and expense tickets and
then lists; Ticket Date, Employee Name; Task; rate; hrs worked; amount;
billable hrs; and ticket status. A header area for each job includes
summary information about the job and customer. This report uses sub
reports to help speed processing in some situations. |
2005 |
|
Aged Payables with comments
|
This is an aged payables report showing
vendor ID & Name, Inv#, Total Amt Due, Inv Date, Due date, Discount amt,
Disc Date, Net to Pay and the line description from the first line of
the invoice as a comment. |
2005 |
|
Budget Worksheet
|
This report pulls
from GL summary info for all accounts with Ids > 4 and with any amounts
in any of the 3 open years (last, this, next) and shows all budget
amounts from this year and actual for this year and last year with entry
lines for next year It prints two accounts / page. This report will
require modification for Peachtree versions > 2002 and crystal>v8 |
2002 |
|
Budget Worksheet 2
|
This report pulls from GL summary info
for all accounts within a specified acct range and shows all budget
amounts from this year and actual for this year and last year with entry
lines for next year. It prints two accounts / page. This report will
require modification for Peachtree versions > 2002 and crystal>v8 |
2002 |
|
Budget Worksheet 3
|
This report pulls
from GL summary info for all accounts with Ids > 4 and with any amounts
in any of the 3 open years (last, this, next) and shows all budget
amounts from this year and actual for this year and last year with entry
lines for next year It prints two accounts / page. This report will
require modification for Peachtree versions > 2002 and crystal>v8 |
2002 |
|
Cash Requirements Report
|
This custom cash requirements report
finds all open AP invoices through an entered as of date. It then
prints; Vendor ID, Name, Inv #, Inv Date, Due Date, Open Inv Amt, Disc
Date, Disc amount and Net cash required. It prints in due date order w/
a daily total due, daily discount available and a running total of cash
required. Discount amounts are not included in the running total. |
2006 |
|
Certified PRForm
|
Custom Certified PR
form for time ticket employees pulled by payPeriod end date and Job.
Showing employee Name, Addr & SS#, sex & ethnic grp from custom fields,
work clfs from empType, std & OT hrs/day w/ totals, pay rates & Gross
pay. A sub report calculates FedW/H, FICA,Other/Union,StateWH, Total
Deducted and Net Job Wages. a Payroll No. may be entered at the entry
prompt. This report will require modification to handle Union/other
deductions based on company default settings. |
2004 |
|
Change in Financial Position
Statement
|
This report is written for a not for
profit organization w/ a departmentalized GL. The first 4 digest of the
GL acctID is the account # and account names are pulled from an Acct w/
the same first 4 digits and on '-' included in the ID. A date range and
beginning fund balance is entered. A running total fund balance is then
printed for Revenues and expenditures w/ activity for main accounts
under these headings shown. Unpaid expenditures (open AP) is then
listed. yielding a net change amount for the period and a final total
fund balance. Can be modified for differing account structures. |
2004 |
|
Check Register by Vendor Expense
Account
|
This custom check
register prints all checks within both a specified Date and Check #
Range. It displays; Check #, Check Date; Payee, Cash Acct DI, Vendor
Default Exp. Acct. and Check Amount. This report subtotals by expense
account. |
2006 |
|
Check Register by Vendor Expense
Account
|
This custom check register prints all
checks within a specified Check Number Range. It displays; Check #,
Check Date; Payee, Cash Acct DI, Vendor Default Exp. Acct. and Check
Amount. This report subtotals by expense account. |
2006 |
|
Check Register by Vendor Expense
Account
|
This custom check
register prints all checks within a specified Date Range. It displays;
Check #, Check Date; Payee, Cash Acct DI, Vendor Default Exp. Acct. and
Check Amount. This report subtotals by expense account. |
2006 |
|
Custom Quote
|
Custom Crystal quote form, pulling a
specific Peachtree quote id from within a specified date range. Detail
shows qty, UoM, quote line description, unit price & extension. There
are detail sale terms and an acceptance signature line. |
2004 |
|
Customer Ledger by Center Type
|
Detail customer
ledger grouped by Customer Type (cost center). Shows Trans Date, Jrnl,
Ref#. Sales amt, Pmt amt & Invoice PD. Note. |
2003 |
|
Customer Ledger by Center Type
|
Customer ledger report grouped by
specified range of customer type. This report shows all transactions
sorted by date. Cash receipts show individual invoices paid and amounts
paid toward that invoice. Columns are, cust.name, jrnl, ref#, sales amt,
pmt amt, running balance ant invoice paid. |
2005 |
|
Customer Sales by Item
|
Lists sales figures
for each item with a valid ID field with detail for each customer
purchasing that product showing Invoice date, # customer and total
amount paid by customer for that product |
2005 |
|
Customer Statement Form
|
Custom customer statement form showing
all customer invoice sorted by invoice # and associated payments with a
running balance. Totally paid invoices are marked and total check
amounts are shown in a comment field. This report was based on a
Peachtree sample report which I later found to not work in all
situations. Aging category totals may not be correct for customers
spanning multiple statement pages. |
2004 |
|
Daily Operations Report w/ Insert
|
This report
summarizes totals for various groups of GL accounts on a daily basis for
an entire month. Same as Daily Operations Report by contains an inserted
sub report showing some other comparison totals for the month. This
report is based on a specific COA and COA structure and would require
considerable modification. |
2002 |
|
Daily Operations Report
|
This report summarizes totals for
various groups of GL accounts on a daily basis for an entire month. This
report is based on a specific COA and COA structure and would require
considerable modification. |
2002 |
|
Daily Orders& Sales
|
This report looks
print a daily summary of the line by line detail of sales invoice and
Sales Orders for a specified range of dates |
2005 |
|
Detail Sales Analysis Report
|
Sales analysis report subtotaled by
customer and sales rep. This report pulls detail for lines that contain
a valid item id and have been assigned a valid sales rep. It shows
invoice # & date, item ID & description. Qty, net sales amount, cost of
sale, gross profit and profit% |
2005 |
|
EE Net/Gross Pay by row
|
Assistance report to
list payroll records by row # to help determine which PR transaction row
# is associated with a specific employee field name. |
2004 |
|
Fees vs. Net Income Chart
|
Compares group of GL income accounts
vs. net income for a month then displays each month on a YTD chart. One
chart being displayed for each reporting entity. This report is based on
a specific COA and COA structure and would require considerable
modification. |
2002 |
|
Item Sales by Customer
|
This report shows
sales for a supplied period of time. It is grouped by Item and show
Inv#, InvDate, Customer and Amount with a subtotal by item. |
2005 |
|
Items Sold to Customer
|
Sales report for specified accounting
period listing item sold to customer w/ sales amount, cost, % of total
sales/customer and Item profit % with totals /customer and company. |
2003 |
|
Job Profitability Report - Detail by
Job
|
This report shows job
profitability for a specified date range and 1 specified Job. It creates
a sub report to pull phase descriptions then prints job cost transaction
detail comprised of TransRef, TransDate, JournalCode, Job#, PhaseCode,
PhaseDescription, GL Acct#, RevenueAmt,ExpenseAmt,Profit & Profit %. It
then subtotals first by GL acct, Phase & then Job. This report equates
employees with phases and assumes employee works just 1 job per
paycheck. employer paid tax expenses are included as an expense. |
2005 |
|
Job Profitability Report - Detail by
Job
|
This report shows job profitability for
a specified date range and ALL Jobs. It creates a sub report to pull
phase descriptions then prints job cost transaction detail comprised of
TransRef, TransDate, JournalCode, Job#, PhaseCode, PhaseDescription, GL
Acct#, RevenueAmt,ExpenseAmt,Profit & Profit %. It then subtotals first
by GL acct, Phase & then Job. This report equates employees with phases
and assumes employee works just 1 job per paycheck. employer paid tax
expenses are included as an expense. |
2005 |
|
List of PAID Bills
|
List all AP bills
Paid during an the entered date range sorted by GL account #. Acct# is
first 4 digits of the Account ID. Shows vendor name, Check date, Check#,
Ref.# and Amount and is totaled by GL Acct#. This report would need to
be modified for acct structure. |
2004 |
|
List of UNPAID Bills
|
List all Unpaid AP bills for the
entered date range sorted by GL account #. Acct# is first 4 digits of
the Account ID. Shows vendor name, transaction date, Ref.# and Amount
and is totaled by GL Acct#. This report would need to be modified for
acct structure. |
2004 |
|
MDT Fees Collected Detail-By DM
|
Further breakdown of
Income categories from MDT Fees Collected-By DM report with income
categories still displayed by reporting entity totaling by district
manager, defined within the report. This report is based on a specific
COA and COA structure and would require considerable modification. |
2002 |
|
MDT Fees Collected-By DM
|
Summarizes groups of income accounts
into income categories then displays by reporting entity totaling by
district manager, defined within the report. This report is based on a
specific COA and COA structure and would require considerable
modification. |
2002 |
|
Non-Stock Sales Rep by Invoice
Report
|
This sales report
list all invoices that were Paid during a specified time frame and
shipped on or prior to the end of that time frame or paid prior to the
beginning of that time frame and shipped during for a specified list of
sales reps. This report prints only items with an item class of
Non-Stock and prints; Invoice #, Ship date, inv date, paid date, cust ID
& Name, Item ID and Inv line description, Qty sold, Inv total, Line item
total, COGS amount Profit and Profit% with invoice and sales rep totals.
|
2006 |
|
Open Accounts Payable
|
This report finds open ap as of a
specific date showing vendor id & name, inv#, total due, inv date, due
date, disc amt, disc date, net to pay and any invoice comment. Will
require logic update for newer versions. |
2004 |
|
Payroll Distribution by Job by
Employee ID -Detail Report
|
For a given date
range, list on a job by job basis PR date, Employee ID & Name, Hours and
Expense allocated to a job with subtotals by job and a grand total
sorted by job and employee ID |
2004 |
|
Payroll Distribution by Job -Detail
Report
|
For a given date range, list on a job
by job basis PR date, Employee ID & Name, Hours and Expense allocated to
a job with subtotals by job and a grand total sorted by job and employee
name |
2004 |
|
Payroll Distribution by Job -Summary
Report
|
For a given date
range, list on a job by job basis showing a summary of Hours and Expense
allocated to a job with subtotals by job and a grand total sorted by job
and employee ID |
2004 |
|
Pending (Unpaid) Sales; Rep by
Invoice Report
|
This sales report list all invoices
that have not been paid and have not been shipped as of the end of a
specified date range for a specified list of sales reps. This report
prints only items with an item class of Stock; Master-Stock; Assembly,
Serialized or Serialized-Assemblies and prints; Invoice #, Ship date,
inv date, paid date, cust ID & Name, Item ID and Inv line description,
Qty sold, Inv total, Line item total, COGS amount Profit and Profit%
with invoice and sales rep totals and payment/ship status grouping
invoices by customer name. |
2006 |
|
Periods
|
Sub report showing
the month name for the current year fiscal periods 1-12. |
2002 |
|
Phase ArrayReport
|
Saved sub report moves Phase ID and
Phase Description into an array to be used in some job profitability
reports. |
2005 |
|
Product Price List
|
The is a product
price listing broken out by item type (product line) it shows the item
ID, Description for Sales (or Description), the stocking unit of measure
(as bundle qty) and 2 price columns the first showing price level #1 and
the second showing a 10% discount. The item type is converted to a
product line description within the report and will need to be modified.
Other 2 column reports exist showing various price levels. |
2005 |
|
Purchase for Account
|
Details of each purchase transaction
distributed to a specified GL asst number group for a specified range of
dates. This report is sorted and subtotaled by vendor. This report was
designed for a specific GL account structure. ####-### with the first
for digits being the account # and that last 3 being a specified
reporting entity |
2002 |
|
QDT Fees Collected-By DM
|
Summarizes groups of
income accounts into income categories then displays by reporting entity
totaling by district manager, defined within the report. This report is
based on a specific COA and COA structure and would require considerable
modification. |
2002 |
|
Sales Invoice Register
|
This report prints for all invoices
dated within a specified date range. It lists Document ID, Date, Cust ID
& Name, Terms Desc, Sales amt, Freight amount and invoice total with
summary totals at the end of the report |
2006 |
|
Sales Order/Job Picking List
|
This report selects
from all Open Sales orders, recovers a Job code located in the CustPO
field on Open SO's and Invoices corresponding to that SO. It then
creates a picking report by job and S/O # showing Qty Ordered,
Installed, item ID and SO Line Description, . The same job code must
also be entered on each SO line. Any Description line that has been
entered in all upper case will be highlighted in bold text and is
assumed to be a comment/message rather than a item line. |
2004 |
|
Sales Rep by Invoice Report
|
This sales report list all invoices
that were Paid during a specified time frame and shipped on or prior to
the end of that time frame or paid prior to the beginning of that time
frame and shipped during for a specified list of sales reps. This report
prints only items with an item class of Stock; Master-Stock; Assembly,
Serialized or Serialized-Assemblies and prints; Invoice #, Ship date,
inv date, paid date, cust ID & Name, Item ID and Inv line description,
Qty sold, Inv total, Line item total, COGS amount Profit and Profit%
with invoice and sales rep totals. This report is printed in Customer /
Invoice ID order. |
2006 |
|
Sales Rep by Invoice Report
|
This sales report
list all invoices that were Paid during a specified time frame and
shipped on or prior to the end of that time frame or paid prior to the
beginning of that time frame and shipped during for ALL sales reps. This
report prints only items with an item class of Stock; Master-Stock;
Assembly, Serialized or Serialized-Assemblies and prints; Invoice #,
Ship date, inv date, paid date, cust ID & Name, Item ID and Inv line
description, Qty sold, Inv total, Line item total, COGS amount Profit
and Profit% with invoice and sales rep totals. This report is printed in
Customer / Invoice ID order. |
2006 |
|
Sales Rep by Invoice Ship Date
Report
|
This sales report list all invoices
that were Paid during a specified time frame and shipped on or prior to
the end of that time frame or paid prior to the beginning of that time
frame and shipped during for a specified list of sales reps. This report
prints only items with an item class of Stock; Master-Stock; Assembly,
Serialized or Serialized-Assemblies and prints; Invoice #, Ship date,
inv date, paid date, cust ID & Name, Item ID and Inv line description,
Qty sold, Inv total, Line item total, COGS amount Profit and Profit%
with invoice and sales rep totals. This report is printed in ship-date
order. |
2006 |
|
Sales Rep Report by Item ID
|
This sales report
list all invoices that were Paid during a specified time frame and
shipped on or prior to the end of that time frame or paid prior to the
beginning of that time frame and shipped during for ALL sales reps. This
report prints only items with an item class of Stock; Master-Stock;
Assembly, Serialized or Serialized-Assemblies and prints; Invoice #,
Ship date, inv date, paid date, cust ID & Name, Item ID and Inv line
description, Qty sold, Inv total, Line item total, COGS amount Profit
and Profit% with Item and sales rep totals. This report is printed in
Item / Customer / Invoice ID order. |
2006 |
|
Sales Report by Customer
|
This sales report lists sales detail
for invoices falling in a specified date range. This report prints only
items with an item class of Stock; Master-Stock; Assembly, Serialized or
Serialized-Assemblies and prints; Customer Name, Item ID, Inv #, Inv
Date, Qty Sold, Unit Price Extended Price, Unit Cost, Total Cost, Profit
and Profit %. with subtotals by Customer. Total Cost, Profit and Profit
% can be turned off with a prompted selection. |
2006 |
|
Sales Report by Item
|
This sales report
lists sales detail for invoices falling in a specified date range. This
report prints only items with an item class of Stock; Master-Stock;
Assembly, Serialized or Serialized-Assemblies and prints; Customer Name,
Item ID, Inv #, Inv Date, Qty Sold, Unit Price Extended Price, Unit
Cost, Total Cost, Profit and Profit %. with subtotals by Item ID. Total
Cost, Profit and Profit % can be turned off with a prompted selection. |
2006 |
|
This Year
|
Sub report showing the current years
range of dates (month & year only) |
2002 |
|
Vendor Check Detail Report
|
This report shows all
checks for the current accounting period sorted by check reference. I
lists Vendor ID, Name and address on check, Vendor Phone #, Check Date,
Check # and a line for each invoice paid, showing Invoice Date, Ref, and
amount applied to that Invoice and finally a check total. |
2005 |
|
Vendor Check Detail Report by Bank
Acct.
|
This report shows all checks for the
current accounting period subtotaled by cash account and sorted by check
reference. I lists Vendor ID, Name and address on check, Vendor Phone #,
Check Date, Check # and a line for each invoice paid, showing Invoice
Date, Ref, and amount applied to that Invoice and finally a check total. |
2005 |
