Accounts Receivable Report Samples - Sage
1Accounts Receivable Report SamplesAppendix AThis section contains representative samples of the reports available in yourAccounts Receivable module.Samples of the following reports are included. STBACK Repetitive Invoice ListingCustomer InvoiceSales JournalRecap By Division Tax Journal Detail Tax Journal SummaryGross Profit JournalCash Receipts Journal Recap by DivisionDaily Transaction RegisterCustomer ListingCustomer Listing with BalancesCustomer Mailing LabelsCustomer Memo Printing PrintingAccounts Receivable Aged Invoice ReportAccounts Receivable Trial Balance ReportCash Expectation ReportCustomer Sales AnalysisCustomer Sales History by PeriodSales Analysis by SalespersonSalesperson Commission ReportSales Tax Report Summary Invoice DetailMonthly Sales ReportCash Receipts ReportAccounts Receivable Invoice History ReportAccounts Receivable Report Samples
2 General Ledger Posting RecapCustomer Audit ReportDeposit Transaction ReportFinance Charge JournalCustomer StatementsCommission Edit RegisterMatch Credits to Open Invoices ReportCredit Card Settlement ReportAccounts Receivable AnalysisAccounts Receivable Analysis ReportThe following reports appear if the Job Cost module is integrated withAccounts Receivable. Accounts Receivable Sales JournalCash Receipts JournalAccounts Receivable Aged Invoice ReportCash Expectation ReportSThe following report appears if the e-Business Manager module isintegrated with Accounts Receivable.T BACKCustomer ListingThe following report appears if the e-Business Manager and ReturnMerchandise Authorization modules are integrated with AccountsReceivable. Invoice History ReportAccounts Receivable Report Samples
3Repetitive Invoice ListingAccounts Receivable Repetitive Invoice ListingABC Distribution and Service Corp. (ABC)Division Number: 02 WEST SALES OFFICECustomer/ReferenceTerms SalesCode PersonItem Code/CommentTaxScheduleSelect TimesCycle BilledPrintInvoiceG/L Account020400CA6Yes010400Customer PO Number: .181,349.801,349.806/17/20105/31/2010Customer PO Number: Verbal400-01-00400-02-00ATOZ A To Z Carpet Supply0001290.58256.251/17/201017Comment: Monthly Service OrderShip Method: MailSUPPLYMCONTRSales Tax6/7/20105/31/2010AMERCON American Concrete Service0001Freight Amount1/7/201007Comment: Six Month Supply OrderShip Method: UPS GroundSUPPLYInvoice AmountDistribution AmountALLENAP Allen's Appliance Repair0005Start BillingStop BillingLast Billed66.251,250.001/31/2010CA314YesComment: Ship ASAP5/31/2010Ship Method: UPS RED LABELCustomer PO Number: 985-721RSWIDGET400-01-004,143.75AUTOCR Autocraft Accessories00010103001/12/2010CA127YesComment: Order per agreementSTBACKShip Method: UPS GroundWIDGETMCONTRSAMPLEWDPACK5/31/2010Customer PO Number: Verbal400-01-00400-02-00400-01-00400-01-00BAYPYRO Bay Pyrotronics Corp.0001020400CA BA1/6/2010067YesComment: Monthly Service BillingShip Method:MCONTR5/31/2010Customer PO Number: 321400-02-00BAYPYRO Bay Pyrotronics Corp.0002020400CA BA7Yes5/31/2010Ship Method: Next Day AirWDPACKCustomer PO Number: VERBAL400-01-00CAPRI Capri Sailing Ships010400Ship Method: UPS GroundWIDGET314Yes5/31/2010Customer PO Number: 198-675400-01-00CUSTOM Custom Craft Products020300CA4Yes5/31/2010Customer PO Number: 3548766400-01-00400-01-00Division 02 Total:Report Total:Run Date: 5/31/2010 12:07:53PMA/R Date: 5/31/20109,668.751/27/201027Comment:Ship Method: UPS GroundWDPACKWIDGET3,435.001/31/2010CAComment: Special age: 1User Logon: jwsmithAccounts Receivable Report Samples
4Customer Invoice ! " # % & # ' ( )( ) " ! 0 & ( #1 2 3 ' !" " 0 * & , . )./ ! - 4 & .(5 - . )7 # / 6 00 ( )/ # / 68 8 ( 2 ( 69 " : "3 " ' ' 2 *; " " ( * 9(( 6 3 3 !3: &#- ( ## 00 STBACK & # % # !3: Accounts Receivable Report Samples
5Sales JournalAccounts Receivable Sales JournalJournal Posting Date: 5/31/2010Register Number: AR-000005ABC Distribution and Service Corp. (ABC)Division Number: 01 EAST SALES OFFICEInvoice Number/Customer Number Invoice DateItem uleG/L Account5/31/201001Taxable SalesAmountNontaxableSales AmountFreight AmountSales TaxInvoice TotalDistribution .000.001,000.00RSSUPPL R & S Supply IN5/31/201001145.0085.000200WIAVNET Avnet Processing Corp***Credit Limit NET Avnet Processing Corp0.000.00349.00***Credit Limit Exceeded***Comment:SUPPLY400-01-00349.00Division 01 Total - Cash Sales:A/R 007.25Total 586.25Report Total - Cash Sales:A/R 007.250.001,586.25Total Run Date: 5/31/2010 9:53:07AMA/R Date: 5/31/2010Page: 1User Logon: jwsmithAccounts Receivable Report Samples
6Sales JournalRecap By DivisionAccounts Receivable Sales Journal - Recap By DivisionJournal Posting Date: 5/31/2010Register Number: AR-000006ABC Distribution and Service Corp. (ABC)Division Number: 01 EAST SALES OFFICEG/L 1-00400-02-00400-02-01450-10-00Accts. receiv. - East WarehseInventory - East WarehouseSales tax payable - East CntyDistribution sales (history)Service feesService fees - EastCost of Goods 066.00Division 01 Total:1,652.251,652.25STBACKRun Date: 5/31/2010 10:46:22AMA/R Date: 5/31/2010Page: 1User Logon: jwsmithAccounts Receivable Report Samples
7Sales JournalTax Journal DetailAccounts Receivable Sales Journal - Tax Journal DetailJournal Posting Date: 5/31/2010Register Number: AR-000010ABC Distribution and Service Corp. (ABC)Division Number: 01 EAST SALES OFFICETax CodeInvoiceNumberDescriptionSales AmountDateWITaxable SalesNontaxableSalesTaxable FreightNontaxableFreightTaxable TaxExempt SalesSales TaxAmountWisconsin0100046-IN5/31/2010WI 5.000.000.000.000.000.007.25Division 01 Total:7.25Report Total:7.25STBACKRun Date: 5/31/2010 8:14:18AMA/R Date: 5/31/2010Page: 1User Logon: jwsmithAccounts Receivable Report Samples
8Sales JournalTax Journal SummaryAccounts Receivable Sales Journal - Tax Journal SummaryJournal Posting Date: 5/31/2010Register Number: AR-000006ABC Distribution and Service Corp. (ABC)Tax Code/DescriptionSales AmountWI Wisconsin1,579.00Taxable Sales145.00NontaxableSales1,085.00Taxable Freight0.00NontaxableFreightTaxable Tax0.000.00Exempt SalesSales TaxAmount349.007.25Report Total:7.25STBACKRun Date: 5/31/2010 10:46:46AMA/R Date: 5/31/2010Page: 1User Logon: jwsmithAccounts Receivable Report Samples
9Gross Profit JournalAccounts Receivable Gross Profit JournalJournal Posting Date: 5/31/2010Register Number: AR-000005ABC Distribution and Service Corp. (ABC)Division Number: 01 EAST SALES OFFICEInvoice Number/CustomerInvoice DateSalesPerson0100045-IN02005/31/2010RSSUPPL R & S Supply Corp.0100046-INCommissionRateNet SalesAmountCost of GoodsSold AmountGross 85.00230.0066.00164.0071.30 %Net Invoice Total:230.0066.00164.0071.30 %8.000 %SUPPLYMCONTRSales Subject To 00.001,000.00100.00 %Net Invoice Total:1,000.000.001,000.00100.00 %8.000 %SUPPLYSales Subject To Commission:349.000.00349.00349.000.00349.00100.00 %Net Invoice Total:349.000.00349.00100.00 %Division 01 Total - Sales Subject To Commission:1,579.0066.001,513.0095.82 %Net Invoice Total:1,579.0066.001,513.0095.82 %Report Total - Sales Subject To .0095.82 %95.82 %5/31/201002005/31/20100200AVNET Avnet Processing CorpSalesCommCommissionAmountInvoice TotalWI8.000 %100-AAMAINTSales Subject To Commission:AVNET Avnet Processing Corp0100047-INTax ScheduleItem Code54.48 % Yes100.00 % Yes18.40237.25WI0.00 % Yes100.00 % Yes80.001,000.00WINet Invoice Total:100.00 % n Date: 5/31/2010 11:44:28AMA/R Date: 5/31/2010Page: 1User Logon: jwsmithAccounts Receivable Report Samples
10Cash Receipts JournalCash Receipts JournalRegister Number: CR-000004ABC Distribution and Service Corp. (ABC)Cash DepositsCustomer Number\NameCommentInvoice NumberAmount AppliedBank: D Wells Fargo Checking01-ABFDiscount DateDiscount AmountDeposit Date:American Business Futures0100034-IN5/31/2010Invoice BalanceDeposit Number: 00009Credit MiscAccountCredit A/RDeposit Amount:10.00Check Number: 334510.000.002,457.6110.00Posting Total:10.000.0010.000.0001-ABF Total:10.000.0010.000.0001 Total:10.000.0010.000.00Deposit 00009 Total:10.000.0010.000.00STBACKRun Date: 5/31/2010 10:51:41AMA/R Date: 5/31/2010Page: 1User Logon: jwsmithAccounts Receivable Report Samples
11Cash Receipts JournalRecap by DivisionAccounts Receivable Recap By DivisionRegister Number: CR-000003ABC Distribution and Service Corp. (ABC)Division Number: 01 EAST SALES OFFICEG/L AccountDescription101-01-00105-00-01Cash in bank - Reg. checkingAccts. receiv. - East WarehseDebitCredit50.0050.00Division 01 Total:50.0050.00STBACKRun Date: 5/31/2010 9:55:22AMA/R Date: 5/31/2010Page: 1User Logon: jwsmithAccounts Receivable Report Samples
12Daily Transaction RegisterDaily Transaction RegisterABC Distribution and Service Corp. (ABC)Postings For: 5/31/2010Source JournalAccount NumberAccount Description/Posting CommentAR-000006105-00-01Accts. receiv. - East WarehseA/R Invoice Entry - 5/31/2010Inventory - East WarehouseR & S Supply Corp. REF: 0100045Sales tax payable - East CntyR & S Supply Corp. REF: 0100045Distribution sales (history)R & S Supply Corp. REF: 0100045Distribution sales (history)Avnet Processing Cor REF: 0100047Service feesAvnet Processing Cor REF: 0100046Service fees - EastR & S Supply Corp. REF: 0100045Cost of Goods SoldR & S Supply Corp. REF: 0100045Journal 000006 Totals:Source AR Totals:5/31/2010 Totals:Report n Date: 5/31/2010 10:48:28AMA/R Date: 5/31/2010Page: 1User Logon: jwsmithAccounts Receivable Report Samples
13Customer ListingCustomer ListingSorted by Customer NumberPermanent Customers OnlyABC Distribution and Service Corp. (ABC)Customer Number:01 - ABFName: American Business FuturesAddress: 2131 N. 14th StreetSort Field: AMERSuite 100Open Item Customer: YesAccounting DepartmentTemporary Customer: NoCity: MilwaukeeState: WIItem Code: WIDGETZIP Code: 53205-12048" x 10" WidgetsCountry: USA United States of AmericaResidential Address: NoPrimary Contact: ARTIE JOHNArtie JohnsonTelephone: (414) 655-4787Fax:Extension: 219Price Level: 1Default Payment Type: CREDIT CARDBatch Fax: NoE-mail: artie@abf.comE-mail Statement: NoURL: www.abf.comTerms Code: 01Salesperson: 0100Net 30 DaysJim KentleyShip Code: UPS BLUEPrimary Ship To: 2American Business FuturesTax Schedule: WI MILMIL MilwaukeeDiscount Rate: 0.000%Finance Charge Rate: 1.500%Customer Type: A2Statement Cycle: MPrint Dunning Message: YesComment: Call Ed for credit approval.Credit Hold:NoCredit Limit: 120,000.00STBACKRun Date: 5/31/2010 4:31:19PMA/R Date: 5/31/2010Page: 1User Logon: jwsmithAccounts Receivable Report Samples
14Customer Listing with BalancesCustomer Listing with BalancesSorted by Customer NumberABC Distribution and Service Corp. (ABC)Customer Number:01-ABFName:American Business FuturesAddress: 2131 N. 14th StreetSort Field: AMERSuite 100Open Item Customer: YesAccounting DepartmentTemporary Customer: NoCity: MilwaukeeState: WIZIP Code: 53205-1204Country: USAUnited States of AmericaItem Code: WIDGET8" x 10" WidgetsResidential Address: NoPrimary Contact: ARTIE JOHNPrice Level: 1Artie JohnsonExtension: 219Telephone: (414) 655-4787Default Payment Type: CREDIT CARDBatch Fax: NoFax:E-mail: artie@abf.comE-mail Statement: NoURL: www.abf.comTerms Code: 01Net 30 DaysSalesperson: 0100Discount Rate: 0.000%Jim KentleyFinance Charge Rate: 1.500%Ship Code: UPS BLUEPrimary Ship To: 2Customer Type: A2American Business FuturesStatement Cycle: MPrint Dunning Message: YesTax Schedule: WI MILMIL MilwaukeeComment: Call Ed for credit approval.Credit Hold: NoCredit Limit: 120,000.00A/R Balance:Aging As Of: 5/31/2010CurrentS30 Days3,252.3860 Days1,222.58Date Established: 1/1/2009TBACK40Fiscal Period: 05Last Finance Charge Date:864.25Average Days to Pay:Fiscal Year: 2010Sales:Cost of Goods Sold:Profit Percent:Cash Received:Number of Invoices:Unpaid Finance Charges:Period To 180.0003,462.544/30/201043.89Prior Year15,520.85Number of Finance Charges:A/R Date: 5/31/2010Year To Date10,178.35Finance Charges:Run Date: 5/31/2010 4:34:25PM0.00Highest Balance:Last Payment Date: 5/31/2010Average Days Overdue:5,732.36120 Days0.00Last Statement Date: 5/1/2010Date of Last Activity: 5/31/2010Last Payment Amount:90 8.5021Page: 1User Logon: jwsmithAccounts Receivable Report Samples
15Customer Mailing LabelsSTBACKAccounts Receivable Report Samples
16Customer Memo PrintingCustomer Memo PrintingABC Distribution and Service Corp. (ABC)Account Number/Description:Memo: ABF-051490Expiration Date:ABFMemo Description:Invoicing policyReminder Start Date:Memo Date:Reminder End Date:5/14/201Auto Display: AlwaysPlease ensure that all invoices for a given month are mailed by the last working day of the month. This will result in prompt receipt ofpayment from American.Memo: ABF-12Expiration Date:Memo Description:Credit checkingReminder Start Date:Memo Date:Reminder End Date:5/31/201Auto Display: NeverTO A/R STAFF: Please review the Aging Report weekly for American. They do not have a credit limit, however, they should not have morethan 10,000.00 in new invoices since their last payment.If they have exceeded this limit, please call Jim Swinter at American to request a payment of at least 2,500.00. This is per our agreementwith Jim. The new invoice may be approved immediately.STBACKRun Date: 5/31/2010 1:38:34PMG/L Date: 5/31/2010Page: 1User Logon: jwsmithAccounts Receivable Report Samples
17Accounts Receivable Aged Invoice ReportAccounts Receivable Aged Invoice ReportSorted by Customer NumberAged as of 05/31/2010ABC Distribution and Service Corp. (ABC)Customer/Invoice DateInvoiceNumberDue DatesInvoiceDiscountDiscountAmountBalanceCurrent30 Days60 Days90 DaysDaysDelq120 DaysCustomer Number: an Business mer ABF Totals:Artie JohnsonPhone: (414) 655-4787Extension: 219Credit er Number: 10Contact:Avnet Processing ustomer AVNET Totals:Tony SchultzPhone: (414) 225-2635Credit .751,795.120.000.000.003131Customer Number: 01BRESLINSBreslin Parts SupplyContact:Balance Foward:5/15/2010 0100035-IN5/15/20105/15/2010 PAYMENT5/21/2010 0100044-IN5/21/20105/27/2010 0100040-IN5/27/20105/29/2010 0000171-IN5/29/20105/29/2010 0000172-IN6/28/2010 6/8/20105/31/2010 0000193-IN5/31/20105/31/2010 0000194-IN6/30/2010 6/10/20105/31/2010 PAYMENT*** Credit Limit Exceeded ***Customer BRESLIN Totals:TReport Totals:Number of Customers:3Winnie e: (414) it un Date: 5/31/2010 2:24:50PMA/R Date: 5/31/2010Page: 1User Logon: jwsmithAccounts Receivable Report Samples
18Accounts Receivable Trial Balance ReportAccounts Receivable Trial BalanceAll Open Invoices as of 5/31/2010ABC Distribution and Service Corp. (ABC)Division Number: 01 EAST SALES OFFICEDatesCustomer/DueDiscountInvoice Number InvoiceInvoice AmountDiscount AmountInvoice BalanceTransactionType DateAmountCheckNumber/TypeDepositDateABF American Business 1/2010C/M5/31/201047.56- Reference: 30/2010Customer ABF Totals:500.00- .48- 2.36F/C5/15/201081.4843.895,732.36AVNET Avnet Processing 101,000.00- 1/20101,751.004,041.0044.120.00Customer AVNET Totals:8,377.370.007,377.377,377.37Division 01 013,109.7313,109.73Number of Customers:5/31/201044.122Report Totals:Number of Customers:44.12INV2TBACKRun Date: 5/31/2010 3:09:50PMA/R Date: 5/31/2010Page: 1User Logon: jwsmithAccounts Receivable Report Samples
19Cash Expectation ReportCash Expectation ReportCash Expected as of 5/31/2010ABC Distribution and Service Corp. (ABC)Division Number: 01 EAST SALES OFFICEDue DatesInvoiceDiscountCustomer/Invoice DateInvoiceNumberABFAmerican Business FuturesDiscountAvailableInvoice BalanceContact:Payments Due e:(414) 7.40407.402,467.61130.00
Cash Deposit s Customer Number\Name Invoice Number Amount Appli ed Discount Date Discount Amount Invoice Bala nce Credit A/R Credit Misc Comment Account Bank: D We ls Fargo Checking Deposit Date: 5/31/2010 Deposit Number: 00009 Deposit Amount: 10.00 01-ABF American Business Futures Check Number: 3345 0100034-IN 10.00 0.00 2,457.61 10.00
Accounts receivable 100 Sales 100 Accounts Receivable Allowance for Doubtful Accounts Beg. 500 25 Beg. End. 600 25 End. Sale 100 Slide 7-22 UCSB, Anderson Accounting for A/R and Bad Debts Collected of 333 on account ? Cash 333 Accounts receivable 333 Accounts Receivable Allowance for Doubtful Accounts Beg. 500 25 Beg. End.
Integrate Sage CRM with Sage 300 Use Sage CRM features that are added during integration How to Use this Guide The first five chapters of this guide are for Sage CRM implementers. Chapter 6, "Using Sage CRM with Sage 300," is for Sage CRM users. We assume that implementers: Have experience implementing and troubleshooting Sage CRM
Create a Receivable Document Learning Objectives In this lesson, you will: Examine the Receivable document components Review Receivable document data entry Create a Receivable document Examine the requirements to bill a vendor for a refund Create a Receivable from a template
What is an Accounts Receivable (A/R)? A balance due from a debtor on a current account. Receivable ‐Amounts owing to the State including accounts receivable, loans, notes receivable, and interest. Receivables can be due from private persons, firms, corporations, other agencies,
2. The percent of accounts receivable method uses an analysis of accounts receivable to estimate the amount that will be uncollectible. Percents are usually based on past experience. A business that has experienced a 1.0% rate of uncollectible accounts can reasonably expect that 1.0% of future accounts receivable will become uncollectible.
Structured Finance 31 Debtor-in-possession Financing 32 Factoring 33 Third-Party Vendors 34. Accounts Receivable and Inventory Financing ii Comptroller’s Handbook . Comptroller’s Handbook 1 Accounts Receivable and Inventory Financing Accounts Receivable and Inventory Financing Introduction This booklet describes the fundamentals of .
142 customer accounts receivable 177,965,627 143 other accounts receivable 63,798,926 144 accumulated provision for uncollectible accounts (3,189,707) 145 notes receivable from associated companies 16,024,261 146 accounts receivable from associated companies 936,122 151 fuel stock 550,278 152 fuel stock expense undistributed -
physical invoice by selecting Click here to download the invoice template. The Contracts Accounts Receivable Detail can be accessed from 1. Select Contract for AR page by selecting the View/Add Accounts Receivable (AR) to this contract ( ) icon, then selecting the View this Accounts Receivable (AR) ( ) icon from the Contract page 2.
