monitor your receivables with management reporting · yaged receivables report ycredit balance...
TRANSCRIPT
This class is designed for…• Acclaim users responsible for managing
Account Receivables for the company
ObjectivesReports and journals of A/R
Detailed review and description of each Account Receivables reportReport maintenance
This course will NOT cover…
Acclaim Receivables User OptionsAccounts Receivable statementsPayment Plan processingCash CollectionsGeneral LedgerAutobatching
A/R Reports and Journals
Deposit JournalCash Receipts JournalAged Receivables ReportCredit Balance ReportCash Forecast ReportUnallocated Payments ReportUnearned Discounts Report
Payment Plan RegisterManual Receivables JournalSales Commission JournalService Charge JournalReceivables Open Details ReportTax Adjustment Detail Report
A/R Reports and Journals
Deposit JournalCash Receipts JournalAged Receivables ReportCredit Balance ReportCash Forecast ReportUnallocated Payments ReportUnearned Discounts Report
Payment Plan RegisterManual Receivables JournalSales Commission JournalService Charge JournalReceivables Open Details ReportTax Adjustment Detail Report
These reports provide information that helps you manage your receivables.
A/R Reports and Journals
Deposit JournalCash Receipts JournalAged Receivables ReportCredit Balance ReportCash Forecast ReportUnallocated Payments ReportUnearned Discounts Report
Payment Plan RegisterManual Receivables JournalSales Commission JournalService Charge JournalReceivables Open Details ReportTax Adjustment Detail Report
Along with providing information, these journals update your ledger accounts and history when they are committed.
Report Type
CurrentOnly current entries (entries notcommitted to history) will print on the report
HistoryOnly historical entries (entries committed to history) will print on the report
BothAll entries will print on the report
Report Format
FullFully detailed report prints New page for each entry
MultipleFully detailed report printsMultiple entries per page
BriefShort, non-detailed report prints
SummarySummary information (totals) prints
Start/End Parameters
Journal DateMinimum/Maximum OverdueMinimum/Maximum Overdue BalanceSales RepCurrency
BranchClassCommentCustomerEntry IDInvoice DateInvoice Number
Registers/Journals with the Commit Parameter
Payment Plan RegisterCash Receipts JournalDeposit JournalManual Receivables JournalSales Commission Journal
Commit Parameter
Allows you to move information from the register/journal into historyIf set to YES
All information on the register/journal is placed into history
If set to NOthe information will not be committed to history Information available the next time you print the register/journal
Committing Information to History
Committed Information considered to be historical, not currentYou can print and view historical information You CANNOT edit Use great care when committing information to historyHistorical information remains on system until purged
Committing Information to History
Committed Information considered to be historical, not currentYou can print and view historical information You CANNOT edit Use great care when committing information to historyHistorical information remains on system until purged
Q-MODE MUST BE ENABLED!
Q-MODE MUST BE ENABLED!
Credit Type
CREDIT TYPEALL
NO LIMIT
HOLD
BALANCE
ORDER
COD
CREDIT TYPEALL
NO LIMIT
HOLD
BALANCE
ORDER
COD
Example
Report Date = 06/15
ABC Company Receivables
INVOICE # DATE AMT1638993 05/10 75.001657890 06/09 150.001667896 06/15 25.001669023 06/21 100.001684500 06/26 250.001689344 07/03 175.001692565 07/10 50.001694628 07/17 140.00
ABC Company Receivables
INVOICE # DATE AMT1638993 05/10 75.001657890 06/09 150.001667896 06/15 25.001669023 06/21 100.001684500 06/26 250.001689344 07/03 175.001692565 07/10 50.001694628 07/17 140.00
Period 1: 30Period 2: 30Period 3: 30
Period 1: 30Period 2: 30Period 3: 30
Example
Report Date = 06/15
ABC Company Receivables
INVOICE # DATE AMT1638993 05/10 75.001657890 06/09 150.001667896 06/15 25.001669023 06/21 100.001684500 06/26 250.001689344 07/03 175.001692565 07/10 50.001694628 07/17 140.00
ABC Company Receivables
INVOICE # DATE AMT1638993 05/10 75.001657890 06/09 150.001667896 06/15 25.001669023 06/21 100.001684500 06/26 250.001689344 07/03 175.001692565 07/10 50.001694628 07/17 140.00
CURRENTLY DUE(6/15 to 7/15)
Invoice # Date Amount 1667896 06/15 25.001669023 06/21 100.001684500 06/26 250.001689344 07/03 175.001692565 07/10 50.00
Example
Report Date = 06/15
FUTURES DUE(7/16 and Beyond)
Invoice # Date Amount1694628 07/17 140.00
ABC Company Receivables
INVOICE # DATE AMT1638993 05/10 75.001657890 06/09 150.001667896 06/15 25.001669023 06/21 100.001684500 06/26 250.001689344 07/03 175.001692565 07/10 50.001694628 07/17 140.00
ABC Company Receivables
INVOICE # DATE AMT1638993 05/10 75.001657890 06/09 150.001667896 06/15 25.001669023 06/21 100.001684500 06/26 250.001689344 07/03 175.001692565 07/10 50.001694628 07/17 140.00
Example
Report Date = 06/15
PAST DUE0-30
Invoice # Date Amount1657890 06/09 150.00
31-60Invoice # Date Amount1638993 05/10 75.00
ABC Company Receivables
INVOICE # DATE AMT1638993 05/10 75.001657890 06/09 150.001667896 06/15 25.001669023 06/21 100.001684500 06/26 250.001689344 07/03 175.001692565 07/10 50.001694628 07/17 140.00
ABC Company Receivables
INVOICE # DATE AMT1638993 05/10 75.001657890 06/09 150.001667896 06/15 25.001669023 06/21 100.001684500 06/26 250.001689344 07/03 175.001692565 07/10 50.001694628 07/17 140.00
Aging Basis
Indicates whether aging is done
according to due date or invoice
date
Indicates whether aging is done
according to due date or invoice
date
Age Credits
Indicates whether credits are aged or treated as current
Yes Credit balances appear across the aging columns
No Credits included “Current” column (no entries in the aging columns)
Indicates whether credits are aged or treated as current
Yes Credit balances appear across the aging columns
No Credits included “Current” column (no entries in the aging columns)
Discount and Future Aging
Determines if Discount and Future Aging information is
included on the report
Determines if Discount and Future Aging information is
included on the report
Aging Periods
Functions the same as the Aging Options of the Aged
Receivables Report
Functions the same as the Aging Options of the Aged
Receivables Report
Credit Balance Report Sample
COMPANY: TIMELY SUPPLY ACCOUNTS RECEIVABLECREDIT BALANCE REPORT
CUST REP NAME A/R-CUST CRED LIMIT F/S LAST PMT HIGH CRED OPEN ORDERS YTD SALES 1ST SALE
INV DATE INVOICE# DESCRIPTION COMM# CURRENT 31 - 60 61 - 90 OVER 90
GROUP 1 BRANCH 1
ABCTOO 100 ABC TOOL COMPANY No L 0 ? 281.40 3,454.12 08/04/01
07/29/99 1000536-1-0 07/29/99 09:35:45 0 22.4007/29/99 1000539-1-0 07/29/99 09:54:41 0 206.0007/29/99 1000546-1-0 07/29/99 12:52:11 0 53.00
-------------- -------------- -------------- --------------OPEN CREDIT -2,029.05 0.00 281.40 0.00 0.00
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------COMPANY: TIMELY SUPPLY ACCOUNTS RECEIVABLE 07/05/02 15:27 PAGE 2
CREDIT BALANCE REPORTBRANCH SUMMARY
GROUP BRANCH OPEN CREDIT CURRENT 31 - 60 61 - 90 OVER 90
1 1 281.40 0.00 281.40 0.00 0.00-------------- -------------- -------------- -------------- --------------
TOTALS 281.40 0.00 0.00 0.00 0.00
NUMBER OF RECEIVABLES 0 3 0 0
Forecast Period
Defines the number of days in each of the nine equally spaced
time periods
Defines the number of days in each of the nine equally spaced
time periods
Forecast Report Sample
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE CASH FORECAST REPORT
CUST NAMEREP OPEN A/R CURRENT 31 - 60 61 - 90 91 - 120 121 - 150 151 - 180 181 - 210 211 - 240 OVER - 240
GROUP 1 BRANCH 1BES100 BEST FOODS - STORE #100
100 713 354 359 0 0 0 0 0 0 0----------- ----------- ----------- ----------- ----------- ----------- ----------- ----------- ----------- -----------
TOTALS 713 354 359 0 0 0 0 0 0 0_________________________________________________________________________________________________________________COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:20 PAGE 2
CASH FORECAST REPORTBRANCH SUMMARY
GROUP BRANCH OPEN A/R CURRENT 31 - 60 61 - 90 91 - 120 121 - 150 151 - 180 181 - 210 211 - 240 OVER - 240
1 1 14,632 12,917 243 1,220 252 0 0 0 0 0----------- ----------- ----------- ----------- ----------- ----------- ----------- ----------- ----------- -----------
TOTALS 14,632 12,917 243 1,220 252 0 0 0 0 0
NUMBER OF RECEIVABLES 14 1 5 1 0 0 0 0 0
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE CASH FORECAST REPORT
CUST NAMEREP OPEN A/R CURRENT 31 - 60 61 - 90 91 - 120 121 - 150 151 - 180 181 - 210 211 - 240 OVER - 240
GROUP 1 BRANCH 1BES100 BEST FOODS - STORE #100
100 713 354 359 0 0 0 0 0 0 0----------- ----------- ----------- ----------- ----------- ----------- ----------- ----------- ----------- -----------
TOTALS 713 354 359 0 0 0 0 0 0 0_________________________________________________________________________________________________________________COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:20 PAGE 2
CASH FORECAST REPORTBRANCH SUMMARY
GROUP BRANCH OPEN A/R CURRENT 31 - 60 61 - 90 91 - 120 121 - 150 151 - 180 181 - 210 211 - 240 OVER - 240
1 1 14,632 12,917 243 1,220 252 0 0 0 0 0----------- ----------- ----------- ----------- ----------- ----------- ----------- ----------- ----------- -----------
TOTALS 14,632 12,917 243 1,220 252 0 0 0 0 0
NUMBER OF RECEIVABLES 14 1 5 1 0 0 0 0 0
Unallocated Payment Report Sample
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:21 PAGE 1UNALLOCATED PAYMENTS REPORT
CUST NAME JRNL DATE TYPE CHECK# ENTRY ID PAYMENT UNALLOCATED
GROUP 1 BRANCH 1
ABCTOO ABC TOOL CORPORATION 05/25/02 CK 2423 JAS 05/25/02 123.00 123.00ABCTOO ABC TOOL CORPORATION 06/12/02 CK 2535 JAS 06/12/02 325.00 25.00
-------------- --------------TOTAL FOR ABCTOO 448.00 148.00
COAMOV COASTAL MOVERS 05/27/02 CK 3476 KAT 05/27/02 75.00 75.00-------------- --------------
TOTAL FOR COAMOV 75.00 75.00_____________________________________________________________________________________________________________COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:21 PAGE 2
UNALLOCATED PAYMENTS REPORTBRANCH SUMMARY
GROUP BRANCH PAYMENT UNALLOCATED
1 1 523.00 223.00-------------- --------------
TOTALS 523.00 223.00
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:21 PAGE 1UNALLOCATED PAYMENTS REPORT
CUST NAME JRNL DATE TYPE CHECK# ENTRY ID PAYMENT UNALLOCATED
GROUP 1 BRANCH 1
ABCTOO ABC TOOL CORPORATION 05/25/02 CK 2423 JAS 05/25/02 123.00 123.00ABCTOO ABC TOOL CORPORATION 06/12/02 CK 2535 JAS 06/12/02 325.00 25.00
-------------- --------------TOTAL FOR ABCTOO 448.00 148.00
COAMOV COASTAL MOVERS 05/27/02 CK 3476 KAT 05/27/02 75.00 75.00-------------- --------------
TOTAL FOR COAMOV 75.00 75.00_____________________________________________________________________________________________________________COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:21 PAGE 2
UNALLOCATED PAYMENTS REPORTBRANCH SUMMARY
GROUP BRANCH PAYMENT UNALLOCATED
1 1 523.00 223.00-------------- --------------
TOTALS 523.00 223.00
Unearned Discounts Report Sample
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLEUNEARNED DISCOUNT REPORT
CUST NAME REP NAMEINVOICE# INV DATE TYPE CHECK# PMT DATE DISC DATE OVERDUE PMT AMOUNT DISC TAKEN DISC AVAIL UNEARNED
GROUP 1 BRANCH 1AAGIND AAG INDUSTRIES 143 RALPH WRIGHTSTONE1070200- 0001 06/ 01/ 02 CC 06/ 18/ 02 06/ 11/ 02 7 140.00 2.80 0.00 2.80
-------------- ------------- ------------- ------------ -TOTAL FOR AAGIND 140.00 2.80 0.00 2.80
______________________________________________________________________________________________________________________________________
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:26 PAGE 2UNEARNED DISCOUNT REPORT
BRANCH SUMMARYGROUP BRANCH PMT TOTAL DISC TAKEN DISC AVAIL UNEARNED DISC
1 1 590.00 52.98 4.86 48.12------------- ------------- ------------- --------------
TOTALS 590.00 52.98 4.86 48.12
Payment Plan Register Sample
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE PAYMENT PLAN INVOICE REGISTER
01/01/50 - 06/16/02
CUSTNAME ORIG INVOICE# GEN DATE INV DATE DUE DATE DISC DATE ORIG INV ORIG DISC ENTRY ID
GEN INVOICE# DUE DATE DISC DATE GEN INV GEN DISC
GROUP 1 BRANCH 1
BES100BEST FOODS - STORE #100 1000604-0001 05/12/02 05/12/02 05/12/02 05/12/02 717.33 0.00 JAM 05/12/02
1000604-0001-01 06/26/02 06/26/02 358.67 0.001000604-0001-02 07/26/02 07/26/02 358.66 0.00
Payment Type
All
Check
Cash
Credit Card
Adjustment
Wire Transfer
All
Check
Cash
Credit Card
Adjustment
Wire Transfer
Cash Receipts Journal Sample
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:23 PAGE 1CASH RECEIPTS JOURNAL
01/01/50 - 06/16/02
CUSTNAME JRNL DATE GROSS PMT NET PMT TP CHECK# CASH ACCOUNT ENTRY ID
INVOICE# INV DATE GROSS PAID NET DISC PAID WRITE-OFF ACCOUNT ORIGINAL A/R CD
GROUP 1 BRANCH 1
BES100 BEST FOODS 05/12/02 15.00 15.00 CM 01-360-550 JAS 05/12/02
1900006-0000 05/12/02 15.00 15.00 0.00 0.00-------------- -------------- -------------- --------------
TOTAL FOR BES100 15.00 15.00 0.00 0.00
COAMOVCOASTAL MOVERS 05/27/02 75.00 75.00 CK 8494 01-110-004 KAT 052702
1000663-0001 05/27/02 75.00 75.00 0.00 230.00
COAMOVCOASTAL MOVERS 06/07/02 3.28 3.28 CA 01-110-004 KAT 060702
1000656-0001 05/23/02 3.28 3.28 0.00 3.28--------- ------------------- ------------- --------------
TOTAL FOR COAMOV 78.28 78.28 0.00 0.00
Cash Receipts Journal SampleCOMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE
CASH RECEIPTS JOURNAL01/01/50 - 06/16/02
BRANCH SUMMARY
GROUP BRANCH TOTAL PAYMENT1 1 8,593.28
-----------------TOTALS 8,593.28
--------------------------------------------------------------------------------------------------------------------------------------COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE
CASH RECEIPTS JOURNAL01/01/50 - 06/16/02
PAYMENTS SUMMARY
GROSS ACCOUNTS RECEIVABLE 8,593.28TOTAL NUMBER OF PAYMENTS 36
ACCOUNT# NAME AMOUNT01-110-004 CASH-IN BANK 8,578.28 01-120-001 ACCOUNTS RECEIVABLES -8,593.2801-470-100 CASH DISCOUNT ALLOWED 0.0001-360-550 FREIGHT-OUTGOING 15.00
---------------TOTAL 0.00
PAYMENT TYPE COUNT AMOUNT
Check 12 5,075.00Cash 19 2003.28Credit Card 2 1,500.00Credit Memo 1 15.00Adjustment 2 0.00
--------------TOTAL 8,593.28
Deposit Journal SampleCOMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE
DEPOSIT JOURNAL06/01/02 - 06/16/02
CASH ACCOUNT: 01-110-004 CASH-IN BANK DEPOSIT DATE: 06/10/02
CUST NAME JRNL DATE ENTRY ID TYPE CHECK# AMOUNT POSTDATED?
GROUP 1 BRANCH 1
ABCTOO ABC-TOOL CORPORATION 06/01/02 PAM 060102 CK 2423 123.00 NOACMTOO ACME TOOL & DIE 06/09/02 JDK 060902 CK 1233 456.00 NOCOAELE COAST ELEC. & PLUMBING 06/10/02 JDK 061002 CK 660 500.00 NOCOAMOV COASTAL MOVERS 06/15/02 KTT 061502 CK 8494 75.00 NO
--------------TOTAL 1,154.00
________________________________________________________________________________________________________
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE DEPOSIT JOURNAL
BRANCH SUMMARY06/01/02- 06/16/02
GROUP BRANCH TOTAL
1 1 1,154.00-----------------
TOTAL 1,154.00
Deposit Journal Sample
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE DEPOSIT JOURNALDEPOSIT SUMMARY
06/01/02 - 06/16/02
DISTRIBUTORS INC. DEPOSIT DATE: 06/16/0219 W.COLLEGE AVE.YARDLEY PA 19067
01-110-004 CASH-IN BANKTOTAL CASH: 320.28
CHECK# ABA# AMOUNT
2423 123.001233 456.00660 500.008494 75.00
--------------
NUMBER OF CHECKS: 4 TOTAL CHECKS: 1,154.00======================
TOTAL DEPOSITS: 1,154.00
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE DEPOSIT JOURNALDEPOSIT SUMMARY
06/01/02 - 06/16/02
DISTRIBUTORS INC. DEPOSIT DATE: 06/16/0219 W.COLLEGE AVE.YARDLEY PA 19067
01-110-004 CASH-IN BANKTOTAL CASH: 320.28
CHECK# ABA# AMOUNT
2423 123.001233 456.00660 500.008494 75.00
--------------
NUMBER OF CHECKS: 4 TOTAL CHECKS: 1,154.00======================
TOTAL DEPOSITS: 1,154.00
Manual Receivables Journal Sample
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:24 PAGE 1MANUAL RECEIVABLES JOURNAL
01/01/50 - 06/16/02
CUST NAMEINVOICE# INV DATE DESC COMM# POST? REP TKR REP COMM TKR COMM ENTRY
IDGROSS SALES STATE TAX OTHER TAX OUT FREIGHT IN FREIGHT PHONE MISC
PREPAID
GROUP 1 BRANCH 1
ABCTOO ABC-TOOL CORPORATION1861852-0000 06/12/02 0 YES 100 0 0.00 0.00 061202
,235.00 220.900 14.10 0.00 0.00 0.00 0.00 0.00 0.00------------- ------------- ------------- ------------- ------------- ------------- ------------- ------------- -------------
235.00 220.90 14.10 0.00 0.00 0.00 0.00 0.00 0.00
HALSAL HALL SALES CO.1845789-0000 06/15/02 0 YES 101 0 0.00 0.00 061502
500.00 470.00 30.00 0.00 0.00 0.00 0.00 0.00 0.00------------- ------------- ------------- ------------- ------------- ------------- ------------ - ------------- -------------
500.00 470.00 30.00 0.00 0.00 0.00 0.00 0.00 0.00
Manual Receivables Journal Sample
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:24 PAGE 2MANUAL RECEIVABLES JOURNAL
01/01/50 - 06/16/02BRANCH SUMMARY
POSTING AMOUNTS
GRP BR GROSS SALES STATE TAX OTHER TAX OUT FREIGHT IN FREIGHT PHONE MISC PREPAID
1 1 8,287.00 7,789.78 497.22 0.00 0.00 0.00 0.00 0.00 0.00------------- ------------- ------------- ------------- ------------- ------------- ------------- ------------- ------------
TOTAL 8,287.00 7,789.78 497.22 0.00 0.00 0.00 0.00 0.00 0.00
AMOUNT ACCOUNT7,789.78 01-120-001 ACCOUNTS RECEIVABLES
- 7,789.78 01-310-100 STOCK SALES497.22 01-490-100 INCOME TAX-FEDERAL
- 497.22 01-490-200 INCOME TAX-STATE--------------
TOTAL 0.00
Sales Commission Journal Sample
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:26 PAGE 1SALES COMMISSION JOURNAL
01/01/50 - 06/16/02
CUST NAMEJRNL DATE INVOICE# INV DATE REP NAME SALES AMOUNT REP COMM
GROUP 1 BRANCH 1
COAMOV COASTAL MOVERS05/27/02 1000656-0001 05/23/02 104 FRED BENTELE 3, 899.00 194.95
101 PHILIP RUSSELL 116.97-------------- --------------
TOTAL FOR COAMOV 3,899.00 311.92____________________________________________________________________________________________________________
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:26 PAGE 2SALES COMMISSION JOURNAL
BRANCH SUMMARY01/01/50 - 06/16/02
GROUP BRANCH SALES AMOUNT REP COMMISSION1 1 3,899.00 311.92
-------------- --------------TOTAL 3,899.00 311.92
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:26 PAGE 1SALES COMMISSION JOURNAL
01/01/50 - 06/16/02
CUST NAMEJRNL DATE INVOICE# INV DATE REP NAME SALES AMOUNT REP COMM
GROUP 1 BRANCH 1
COAMOV COASTAL MOVERS05/27/02 1000656-0001 05/23/02 104 FRED BENTELE 3, 899.00 194.95
101 PHILIP RUSSELL 116.97-------------- --------------
TOTAL FOR COAMOV 3,899.00 311.92____________________________________________________________________________________________________________
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:26 PAGE 2SALES COMMISSION JOURNAL
BRANCH SUMMARY01/01/50 - 06/16/02
GROUP BRANCH SALES AMOUNT REP COMMISSION1 1 3,899.00 311.92
-------------- --------------TOTAL 3,899.00 311.92
Service Charge Journal SampleCOMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:26 PAGE 1
SERVICE CHARGE JOURNAL01/01/50 - 06/16/02
CUST BILL-TO-NAME SC INVOICE# SC DATE COMMENT SC % AMOUNT OVERDUE SC AMOUNT
GROUP 1 BRANCH 1
BES100 BEST FOODS - STORE #100 1700005-0000 05/27/02 0 1.00 702.33 7.02COLMAC COLORADO MACHINE 1700008-0000 05/27/02 0 1.00 3,055.76 30.56FROELE FROMM ELECTRIC CORP. 1700009-0000 05/27/02 0 1.00 638.12 6.38HVASAL HVAC SALES CO. 1700010-0000 05/27/02 0 1.00 277.26 2.77
_____________________________________________________________________________________________________________COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:26 PAGE 2
SERVICE CHARGE JOURNALBRANCH SUMMARY
01/01/50 - 06/16/02
GROUP BRANCH SERVICE CHARGE AMT
1 1 46.73--------------
TOTAL 46.73
ACCOUNT SUMMARY
AMOUNT ACCOUNT NAME
46.73 01-120-001 ACCOUNTS RECEIVABLES-46.73 01-120-002 MISC. ACCOUNTS RECEIVABLE
--------------TOTAL 0.00
Receivables Open Detail Report Sample
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:28 PAGE 1OPEN RECEIVABLES REPORT
CUST REP NAME CRED LIMIT F/S LAST PMT YTD HIGH CRED OPEN ORDERS YTD SALES 1ST SALEINV DATE INVOICE# DESCRIPTION COMM# CURRENT 31 - 60 61 - 90 OVER 90 PAID
BES100 100 BEST FOODS - STORE #100 No L 0 0 05/12/02 $0.00 $0.00 $717.33 02/27/02
890 HIGHWAY 57BEAR DE 19701312-456-7800
05/12/02 1000604-0001-01 21913-02 80 0.00 358.67 0.00 0.00 0.0005/12/02 1000604-0001-02 21913-02 80 0.00 358.66 0.00 0.00 0.0005/12/02 1900006-0000 INC FREIGHT 0 0.00 -15.00 0.00 0.00 15.0005/27/02 1700005-0000 SRVC CHARGE 0 10.00 0.00 0.00 0.00 0.00
-------------- -------------- -------------- -------------- --------------OPEN A/R 712.33 10.00 702.33 0.00 0.00 15.00
__________________________________________________________________________________________________________________________
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:28 PAGE 2OPEN RECEIVABLES REPORT
BRANCH SUMMARY
GROUP BRANCH OPEN A/R CURRENT 31 - 60 61 - 90 OVER 90 PAID
1 1 712.33 10.00 702.33 0.00 0.00 15.00-------------- -------------- -------------- -------------- -------------- --------------
TOTALS 712.33 10.00 702.33 0.00 0.00 15.00
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:28 PAGE 1OPEN RECEIVABLES REPORT
CUST REP NAME CRED LIMIT F/S LAST PMT YTD HIGH CRED OPEN ORDERS YTD SALES 1ST SALEINV DATE INVOICE# DESCRIPTION COMM# CURRENT 31 - 60 61 - 90 OVER 90 PAID
BES100 100 BEST FOODS - STORE #100 No L 0 0 05/12/02 $0.00 $0.00 $717.33 02/27/02
890 HIGHWAY 57BEAR DE 19701312-456-7800
05/12/02 1000604-0001-01 21913-02 80 0.00 358.67 0.00 0.00 0.0005/12/02 1000604-0001-02 21913-02 80 0.00 358.66 0.00 0.00 0.0005/12/02 1900006-0000 INC FREIGHT 0 0.00 -15.00 0.00 0.00 15.0005/27/02 1700005-0000 SRVC CHARGE 0 10.00 0.00 0.00 0.00 0.00
-------------- -------------- -------------- -------------- --------------OPEN A/R 712.33 10.00 702.33 0.00 0.00 15.00
__________________________________________________________________________________________________________________________
COMPANY: DISTRIBUTORS INC. ACCOUNTS RECEIVABLE 06/16/02 13:28 PAGE 2OPEN RECEIVABLES REPORT
BRANCH SUMMARY
GROUP BRANCH OPEN A/R CURRENT 31 - 60 61 - 90 OVER 90 PAID
1 1 712.33 10.00 702.33 0.00 0.00 15.00-------------- -------------- -------------- -------------- -------------- --------------
TOTALS 712.33 10.00 702.33 0.00 0.00 15.00
Tax Adjustment Detail Report SampleCOMPANY: TIMELY SUPPLY ACCOUNTS RECEIVABLE 07/05/02 15:03 PAGE 1
TAX ADJUSTMENT DETAIL REPORT
SCHD CUST NAME INVOICE# INV DATE JRN DATE ENTRY ID AMOUNT ACCOUNT#
GROUP 1 BRANCH 1
1 FROELE FROMM ELECTRIC CORP. 1000047-0001 06/08/02 06/02/02 LKD 060802 12.61 01-250-0031 BLACKS BLACKSTONE COMPANY 1000533-0001 06/23/02 06/27/02 KAT 062302 0.60 01-490-2006 EDWCON EDWARDS CONTRACTING 1000584-0001 06/25/02 06/25/02 LKD 062502 53.55 01-250-003
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------COMPANY: TIMELY SUPPLY ACCOUNTS RECEIVABLE 07/05/02 15:03 PAGE 2
TAX ADJUSTMENT DETAIL REPORT
GROUP 1 BRANCH 1 TOTALSSchd Amount
1 13.216 53.55
------------TOTAL 66.76
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------COMPANY: TIMELY SUPPLY ACCOUNTS RECEIVABLE 07/05/02 15:03 PAGE 3
TAX ADJUSTMENT DETAIL REPORT
TOTALSSchd Amount
1 13.216 53.55
------------TOTAL 66.76
Summary
Provide an overview of the reports and journals of A/R, including how to maintain themProvide a detailed review & description of the each Account Receivables report
For More Information…Acclaim Help Files
Visit Prophet 21 on the web: www.p21.com
P21 University course offerings
Search the Solutions database
Browse Documentation
Accounts Receivable Manual
Submit a web case
Email Professional Services Sales: [email protected]
Email Consulting Services: [email protected]