You are here: Home / Faq / AR-AP Reports

Frequently Asked Questions

Frequently Asked Question for AR / AP Reports

Welcome to the MSoft International Affiliate Program, the affiliate network with the best accounting software on the Internet. Join for free to our affiliate program, earn money and take some other advantages with the absolute minimum effort.

Open Invoice

1. How do I print Statement?

    ° Click the AR and AP Report menu, go to Open Invoice-Customer and select Statement.

    ° Enter a range of statement of the month end, statement date, customer numbers, agent, area code     and customer control account.

    ° You may tick 'Include Zero Balance' to print statements including customers with zero balance and or tick     'Sort by Date' to print sorting by sequence.You can also choose to print out the 12 Months aging or 6     Months aging in your report.You also can group your listing by Account No, Statement group or Project     code.

    ° Select the Format Code that you want to print.

    Note: This system allows you to modify the report's layout according to your needs at Housekeeping-     Format Setup-Statement.

    ° Click Preview to view report, Print to print report or File to download report to a text file.

    ° Click Exit to cancel.



2. How do I List Unpaid Bill?

    ° Click the AR and AP Report menu, go to Open Invoice - Customer and select List Unpaid Bill.

    ° Enter a range of statement date, customer numbers, agent, area code, project code, job code and     customer control account.

    ° There are 4 additional options to this report. You can choose to include or omit them in your report. Tick     the appropriate box to obtain effect.

    ° You also can sort your listing by A/c No.+billtype+ref or Date in your report.

    ° Click Preview to view report, Print to print report or File to download report to a text file.

    ° Click Exit to cancel.



3. How do I print Aging Report?

    ° Click the AR and AP Report menu, go to Open Invoice-Customer and select Aging Report.

    ° Enter a range of customer numbers, agent, area code, report's date, project code, job code and     customer control account.

    ° There are 9 additional options to this report. You can choose to include or omit them in your report. Tick     the appropriate box to obtain effect.

    ° You can also choose to print out the 12 Months aging, 6 Months aging or the different months or aging in     your report.

    ° Click Preview to view report, Print to print report or File to download report to a text file.

    ° Click Exit to cancel. Print aging report



4. How do I List Unapplied Open Invoices - Customers?

    ° Click the AR and AP Report menu, go to Open Invoice and select List Unapplied Open Invoices-     Customers.

    ° Select the range of parameters to print.

    ° Select the bill type.

    ° Click Preview to view report, Print to print report or File to download report to a text file.

    ° Click Exit to cancel.



5. How do I print Detail Aging Analysis Report?

    ° Click the AR and AP Report menu, go to Open Invoice-Customer and select Detail Aging Analysis     Report.

    ° Enter a range of customer numbers, agent, area code, reports date, statement group and customer     control account.There are 3 additional options to this report. You can choose to include or omit them in     your report. Tick the appropriate box to obtain effect.

    ° You can also choose the format to print out in your report listing.

    ° You can group your listing by Account No. or Statement group and/ or by Customer No or Name in your     report.

    ° Click Preview to view report, Print to print report or File to download report to a text file.

    ° Click Exit to cancel.



6. How do I list and print Payment Audit Trail By Customer?

    ° Click the AR and AP Report menu, go to Knock Off Bill and select Payment Audit Trail By Customer.

    ° Select the range of parameters to print.

    ° Tick on Include C/N to print statements including credit note or Include GJ to print statement with General     Journal.

    ° Otherwise you may tick the check box Sort by Date+Ref to print your report sorted in sequence.

    ° Click Preview to view report, Print to print report or File to download report to a text file.

    ° Click Exit to cancel.



7. How do I list Invoice Audit Trail By Customer?

    ° Click the AR and AP Report menu, go to Knock Off Bill and select Invoice Audit Trail By Customer.

    ° Select the range of parameters to print.

    ° Tick on Include D/N to print statements including credit note.

    ° Otherwise you may tick the check box Sort by Date+Ref to print your report sorted in sequence.

    ° Click Preview to view report, Print to print report or File to download report to a text file.

    ° Click Exit to cancel.



Customers Trasaction

8. How do I print list of transactions showing total bills issued to customers and payments received?

    ° Click the AR and AP Report menu and select Customer Transaction.

    °Select the range of parameters to print

    ° There are 5 additional options to this report. You can choose to include or omit them in your report. Tick     the appropriate box to obtain effect.

    °Click Preview to view report, Print to print report or File to download report to a text file.

    °Click Exit to cancel.



Customers Report

9. How do I print Customer Aging Report?

    ° Click the AR and AP Report menu, and select Customer Aging.

    ° Enter the range of customer numbers, agent, area code, reports date and customer control account.

    ° There are 7 additional options to this report. You can choose to include or omit them in your report. Tick     the appropriate box to obtain effect.

    ° You can also choose to print out the 12 Months aging or 6 Months aging in your report listing.

    ° Click Preview to view report, Print to print report or File to download report to a text file.

    ° Click Exit to cancel.



Sales Analysis

10. How do I print Yearly Sales By Customer?

    ° Click the AR and AP Report menu, go to Sales Analysis and select Yearly Sales By Customer.

    ° Enter a range of dates, customer numbers, area and agent code.

    ° There are 3 additional options to this report. You can choose to include or omit them in your report. Tick     the appropriate box to obtain effect.

        o Credit note and debit note to be included into sales report.

        o A line to separate every customer account.

        o Take in a round figure without decimal point.

    ° Click Preview to view report, Print to print report or File to download report to a text file.

    ° Click Exit to cancel.



SALES ANALYSIS - Yearly Sales Report



11. How to view and print Yearly Sales Report?

    ° Click the AR and AP Report menu, go to Sales Analysis and select Yearly Sales Report

    ° Enter a range of dates, customer numbers, area and agent code.

     Note: There are 2 additional options to this report, where you want to choose to include or omit from your     report. Tick the appropriate box to obtain the following effect.

        o Credit note and debit note to be included into sales report

        o Take in a round figure without decimal point

    ° Click the Excel Graph button to export the data for the Excel. This purpose is created a graph based on     the yearly sales data.

    °Click Preview button to view report, or Print button to print report, or File button to download report to a text     file.

    ° Click Exit to cancel.



SALES ANALYSIS - Top 50 Customer



12. How to view and print Top 50 Customer?

    ° Click the AR and AP Report menu, go to Sales Analysis and select Top 50 Customer

    ° Enter a range of dates, agent and top figure.

    Note: If you want to include credit note and debit note into     sales report, please tick at the checkbox for     with CN/DN.

    ° Click Preview button to view report, or Print button to print report, or File button todownload report to a text     file. Click Exit to cancel.



SALES ANALYSIS-Top 50 Customer



13. How to view and print Top 50 Customer?

    ° Click the AR and AP Report menu, go to Sales Analysis and select Top 50 Customer

    ° Enter a range of dates, agent and top figure.

    Note: If you want to include credit note and debit note into sales report, please tick at the checkbox for     "with CN/DN".

    ° Click Preview button to view report, or Print button to print report, or File button to download report to a text     file.

    ° Click Exit to cancel.



Printing Official Receipt

14. How to print Official Receipt Voucher when amount received from customer in cash or cheque?

    ° Click the AR and AP Report menu, and select Print Official Receipt.

    ° Enter a range of dates, receipt numbers and statement group.

    ° Select the Format Code that you want to print.

    Note:You are able to modify the report's layout according to your needs at Select Housekeeping, Select     Format Setup and click Official Receipt.

    Note: You can choose include or omit Based on pdc date and Statement Group from your report.

    ° Click Preview button to view report, or Print button to print report, or File button to download report to a text     file.

    ° Click Exit to cancel



Listing Post Dated Cheque Received

15. How to list Post Dated Cheque received from customers?

    ° Click AR and AP Report menu, go to List Post Dated Cheque Received and select List Post Dated     Cheque Received.

    ° Enter a range of dates and cheque numbers.

    Note: You are able to modify the reports layout according to your needs at Select Housekeeping, Select     Format Setup and click Payment Voucher.

    Note: This report prints 2 formats: Debit Amount-Amount pay from creditor account or Credit Amount-bank     or cash account figure.

    ° Click Preview button to view report, or Print button to print report, or File button to download report to a text     file.

    ° Click Exit to cancel



16. How to mark Post Dated Cheque Received?

    ° Click AR and AP Report menu, go to Mark Post Dated Cheque Received and select Mark Post Dated     Cheque Received.

    Note: The system will display all unmark post dated cheque received transactions from this year. For every     unmark transaction, please mark the check box.

    Note: If you want to display unmarked transactions, please tick at the check box for Display unmark     transaction only.

    ° Click the Mark All button the system will mark all the post dated cheque accounts transactions from this     year. However, click the Unmark All button, it will prompt a dialog box to ensure proceed.

    ° If you want to display the transactions faster, please key in the Cheque No in the box.

    ° Click Print button to print report, or click Exit to cancel.



Print Customer Transaction by Bill Type

18. How to view and print out the Customer Transaction by Bill Type?

    ° Click the AR and AP Report menu and go to Print Customer Transaction By Bill Type.

    ° Enter the range of customer number, date, agent area, area, project code and bill type to print the report

    ° You can sort your listing by A/c+Date, Date, Reference No and A/c+Description

    ° You can choose include or omit Based on pdc date from your report.

    ° Click Preview button to view report, or Print button to print report, or File button to download report to a text     file.

    ° Click Exit to cancel.



Print Over Credit Limit Listing

19. How to view and print out all the customer whom over credit limit?

    ° Click the AR and AP Report menu and go to Print Over Credit Limit Listing.

    ° Enter the range of customer number, until date, agent and area to print the report.

    ° Click Preview button to view report, or Print button to print report, or File button to download report to a text     file.

    ° Click Exit to cancel.



Remittance Advice

22. How to print the monthly suppliers remittance advice?

    ° Click the AR and AP Report menu and select Remittance Advice.

    ° Enter a range of dates, statement date, supplier numbers, agent, area code and project code.

    ° Select the Format Code that you want to print.

    Note: This system allows you to modify the reports layout according to your needs at Housekeeping ?     Format Setup ? Remittance Advice.

    ° There is an option called Include Zero Balance, tick this check box to print remittance advice including     creditors with zero balance.

    ° You can also choose to print out the 12 Months aging or 6 Months aging in your report listing.

    ° Click Preview button to view report, or Print button to print report, or File button to download report to a text     file. Click Exit to cancel.



Open Invoices - Suppliers

23. How to print monthly suppliers Remittance Advice?

    ° Click the AR and AP Report menu and go to Open Invoices and select Print Remittance Advice.

    ° Enter the range of parameters to print.

    ° Select the Format Code that you want to print.

    Note: This system allows you to modify the reports layout according to your needs at Housekeeping ?     Format Setup ? Remittance Advice.

    ° There are 2 additional options to this advice, which you can choose to include or exclude from your     remittance advice. Tick the appropriate box to obtain the effect.

    ° You can also choose to print out the 12 Months aging or 6 months aging in your report listing.

    ° Click Preview button to view report, or Print button to print report, or File button to download report to a text     file. Click Exit to cancel.



Suppliers Transactions

24. How to print the List Unpaid Bill?

    ° Click the AR and AP Report menu, go to Open Invoices and select List Unpaid Bill.

    ° Enter a range of statement date, supplier numbers, agent, area code, project code, job code, and     suppliers control account.

    ° There are 4 additional options to this report, where you can choose to include or omit from your report.     Tick the appropriate box to obtain the effect.

    ° You can also sort your listing by A/c No.+billtype+ref or Date in your report.

    ° Click Preview button to view report, or Print button to print report, or File button to download report to a text     file. Click Exit to cancel.



25. How to print the Aging Report?

    ° Click the AR and AP Report menu, go to Open Invoices and select Aging Report.

    ° Enter the range of suppliers number, agent, area code, date, project code, job code and suppliers     control account.

    ° There are 6 additional options to this report, where you can choose to include or omit from your report.

    ° You can also choose to print out 12 Months aging or 6 Months aging in your report listing.

    ° You can also choose to print out the different months or aging in your report.

    ° Click Preview button to view report, or Print button to print report, or File button to download report to a text     file. Click Exit to cancel. p>

26. How to print the List Unapplied Open Invoices-Suppliers?

    ° Click the AR and AP Report menu, go to Open Invoices-Suppliers and select List Unapplied Open     Invoices.

    ° Select the range of date and range of supplier numbers to print.

    ° Select the bill type.

    ° Click Preview button to view report, or Print button to print report, or File button to download report to a text     file. Click Exit to cancel. p>

27. How to print Detail Aging Analysis Report?

    ° Click the AR and AP Report menu, go to Open Invoices and select Detail Aging Analysis Report.

    ° Enter the range of supplier numbers, agent, area code, date project code, job code and supplier control     account.

    ° There are 3 additional options to this report, where you can choose to include or omit from your report.     Tick the appropriate box to obtain the effect.

    ° You can choose the format to print out in your report listing.

    ° You can also sort your listing by Supplier No. or Name in your report.

    ° Click Preview button to view report, or Print button to print report, of File button to download report to a text     file. Click Exit to cancel.



28. How to print Payment Audit Trail By Supplier?

    ° Click the AR and AP Report menu, go to Open Invoices and select Payment Audit Trail By Supplier.

    ° Select the range of parameters.

    ° There are options called Include C/N, tick this check box to print statements including credit note and     Include GJ to include General Journal. Otherwise, tick the check box Sort by Date+Ref to print your report sorting by sequence.

    ° Click Preview button to view report, or Print button to print report, or File button to download report to a text     file. Click Exit to cancel.



29. How to print Invoice Audit Trail By Supplier?

    ° Click the AR and AP Report menu, go to Open Invoices and select Invoice Audit Trail By Supplier.

    ° Select the range of parameters to print.

    ° There is an option called ‘Include D/N’, tick this check box to print statements including credit note. Otherwise, tick the check box Sort by Date+Ref to print your report sorting by sequence.

    ° Click Preview button to view report, or Print button to print report, or File button to download report to a text file. Click Exit to cancel. p>

30. How to print Suppliers Transaction?

    ° Click the AR and AP Report menu, and select Suppliers Transaction.

    ° Select the range of parameters.

    ° There are 4 additional options to this report, where you can choose to include or omit from your report. Tick the appropriate box to obtain the effect.

    ° Click Preview button to view report, or Print button to print report, or File button to download report to a text file. Click Exit to cancel. p>

Supplier's Aging Report

31. How to print Suppliers Aging Report?

    ° Click the AR and AP Report menu, and Select Supplier Aging Report.

    ° Enter the range of supplier numbers, agent, area code, date and suppliers control account.

    ° There are 6 additional options to this report, where you can choose to include or omit from your report.     Tick the appropriate box to obtain the effect.

    ° You can also choose to print out the 12 Months aging or 6 Months aging in your report listing.

    ° Click Preview button to view the report, or Print button to print report, or File button to download     report to     a text file. Click Exit to cancel.