MSOFT Business Accounting System

Open Invoice

1. How to print Yearly Purchase By Supplier?

° Click the AR and AP Report menu, go to Purchase Analysis and select Yearly Purchase by Supplier.

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

° 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 following effect.

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

o A line to separate every supplier account

o Take in a round figure without decimal point

° 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.

2. How to print Yearly Purchase Report?

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

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

° There are 2 additional options to this report, where you can 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 purchase 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 purchase 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.

3. How to print Top 50 Suppliers?

° Click the AR and AP Report menu, go to Purchase Analysis and select Top 50 Suppliers.

° Enter a range of date and top figure. If you want to include credit note and debit note into purchase report, please tick at the check box 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.

4. How to print the List of Post Dated Cheque issued to suppliers?

° Click the AR and AP Report menu and select List Post Dated Cheque issued.

° Enter a range of dates, supplier numbers, agent code, area and select the range of account number.

° You can choose to include or omit For expenses Only 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_Suppliers Transaction by Bill Type

5. How to print Suppliers Transaction By Bill Type?

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

° Enter the range of supplier number, date, agent, 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.

° 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.

Supplier Credit Note

6. How to print Supplier Credit Note?

° Click the AP and AR Report menu and select Print Supplier Credit Note.

° Enter the range of date and credit note.

° 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 ? Credit Note-Creditor.

° 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 Supplier Debit Note

7. How to print Supplier Debit Note?

° Click the AR and AP Report menu and select Print Supplier Debit Note.

° Enter the range of date and debit note.

° 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 ? Debtor Note-Creditor.

° 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.

Foreign Currency Report

8. How to print General Ledger, Debtor Ledger or Creditor Ledger reports?

° Click the AR and AP Report menu, go to Foreign Currency Report and select General Ledger.

° Select the range of parameters to print.

° 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

Statement

9. How to print Customer statements?

° Click the AR and AP Report menu, go to Foreign Currency Report, Statement and select Customer.

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

° Tick on 'Include Zero Balance' to print with zero balance statement or 'Sort by date' to print customer statement sorting by date.

° You can also tick either the 12 Months aging or 6 Months aging in your report listing.

° 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 ? F/Currency Debtor Statement.

° 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.

Customer/Supplier Aging Report

CUSTOMER

10. How to view and print Customer Aging Report?

° Click the AR and AP Report menu, go to Foreign Currency Report, Aging Report and select Customer.

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

Note: There are 7 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.

° You can 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.

SUPPLIER

11. How to view and Supplier Aging Report?

° Click the AR and AP Report menu, go to Foreign Currency Report, Aging Report and select Suppliers.

° Enter the range of creditor numbers, agent, area and until date and currency code.

° 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.

° 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.

Gain & Loss Report and Update

CUSTOMER

12.How to view and print Customer's gain and loss report?

° Click the AR and AP Report menu, go to Foreign Currency Report, Gain & Loss Report & Update and select Customer.

° Enter the range of payment date and customer numbers.

° There is an option called 'Include Update Transaction', tick this check box to print statements including customers with update transaction.

° 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

SUPPLIER

13. How to view and print suppliers' gain and loss report?

° Click AR and AP Report menu, go to Foreign Currency Report, Gain & Loss Report & Update and select Supplier.

° Enter the range of payment date and supplier numbers.

° There is an option called 'Include Updated Transaction', tick this check box to print statements including supplier with updated transaction.

° 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

UPDATE

14. How to update the transactions to Accounting System?

° This section allows you to update the transactions to the Accounting System if it is linked, before running this section please remember run the change foreign currency update status.

Print Overdue Letter

15. How to view and print Overdue Letter?

° Click the AR and AP Report menu, go to Foreign Currency Report, and select Print Overdue Letter.

° Enter the range of customer number, until date, format code and currency code to print the overdue letter.

° 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->Print Overdue Letter.

° 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.

Detail Aging Report

CUSTOMER

16. How to print customers detail aging analysis report in different currency rate?

° Click the AR and AP Report Menu, go to Foreign Currency Report, Detailed Aging Report and select Customer.

° Enter the range of customer numbers, agent, area code, until date, currency code, project code, job code and customer 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 also can sort your listing by Customer No or Name 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.

SUPPLIER

17. How to print suppliers detail aging analysis report in different currency rate?

° Click the AR and AP Report menu, go to Foreign Currency Report, Detail Aging Report and select Supplier.

° Enter the range of supplier numbers, agent, area code, until date, currency code, 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 also sort your listing by Customer No or Name 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.

TRIAL BALANCE

18. How to view and print Trial Balance report?

° Click the AR and AP Report menu, go to Foreign Currency Report, Trial Balance and select Trial Balance.

° Select the range of parameters to print.

° This report prints 2 columns: one column showing year-to-date figure and the other showing month-to-date figure. However, there is an option called 'Print Year to date only' and tick this check box to print trial balance showing only year-to-date 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.

Housekeeping

SYSTEM SETUP

19. How to set up company profile?

° Click the Housekeeping menu and select System Setup.

° Enter the following details:

Company Name, Address, ROC Ref. No

Enter your company name address and ROC no.

Customer Control A/C, Supplier Control A/c

Key in default Customer and Supplier Control Account Code. It will always appear in the Customer or Supplier maintenance.

Closing Date

Key in the Closing Date for the company's last accounting year and the duration for the financial year in order for the system to update the company current financial year.

Starting Date

Key in current the year starting accounting date.

Total month

Total accounting month for the year.

Duplicate Reference Number

If allow duplicate reference number, type in 'Y'-Yes.