Accounting System

Accounting system module has been part of our core products since it first started. Our past and existing customers have commented that it is very user friendly and can easily be used by people from any level. This is the one of the business management tools and operational solutions that helps you keep track of the financial situations of your company via comprehensive financial reports. You can also keep track of how well your business sales are via Sales Analyst Report. This accounting module is bound to suit every business need, be it being in a trading company, manufacturing or service line.

Code Setup / Master Maintenance

1. Create Chart of Accounts

2. Entering Opening Balance

3. Maintain Stock Value at every month end in order to generate any reports relating to stock account

4. Maintain Project Titles and Job Titles for different projects

5. Maintain Project and Job opening balance, if applicable

6. Maintain Project Budget for different projects

7. Maintain the budget for various accounts

8. Maintain Debtor / Customer in S$ and Foreign Currency

9. Distribute Debtor / Customer opening balance into relevant month. Applicable to Debtor / Customer using Statement Type = Balance Forward

10. Maintain Debtor / Customer individual outstanding bills. Whenever a payment is made, the amount is offset against an individual bill. Applicable to Debtor / Customer using Statement Type = Open Invoice

11. Maintain Creditor / Supplier in S$ and Foreign Currency

12. Distribute Creditor / Supplier opening balance into relevant month.

13. Maintain Creditor / Supplier individual outstanding bills. Whenever a payment is made, the amount is offset against an individual bill.

14. Maintain multi foreign currency codes & rates for foreign currency transactions

15. Maintain Agent (such as Salesperson) Code

16. Departmental Retained Earnings

17. Maintain Area Code

18. Maintain each fixed asset and its Accumulated Depreciation accounts

AR & AP Report

1. Customers Listing / Label select by customer code, Area, Agent

2. Print Customer statement select by customer Code, Agent, Area, Statement group, project code

3. Listing of unpaid bill by customer, select by customer code, area, agent, project code, job code

4. Listing of unapplied invoice by customer, select by customer code, date

5. Debtor Aging Report in summary / detail, select by customer code, area, agent, project code, job code

6. Payment / Invoice Audit Trail by Customer to showing details of customer number, customer name, area, agent, reference number and amount

7. Listing of customers transactions showing total bills issued to customers and payment received

8. Print Overdue Letter to the customer whose account is overdue

9. Yearly Sales Report by customer, select by customer code, date, area, agent

10. Summary of Yearly Sales Report, select by customer code, area, agent

11. Listing of Top 50 customer , select by date, agent, area

12. Print official receipt to customer whenever there is an amount received either in cash or cheque

13. List of Post Dated Cheque Received from customer that have not deposited into bank

14. Listing of Over Credit Limit, select by customer code, agent, area

15. Suppliers Listing / Label, select by supplier code, agent, area

16. Suppliers remittance advice showing current transaction, purchase amount owing and aging analysis, select by supplier code, agent, area, project code, job code

17. Listing of unpaid bill to supplier, select by supplier code, area, agent, project code, job code

18. Listing of unapplied invoice to supplier, select by supplier code, date

19. Creditor Aging in summary / detail, select by supplier code, agent, area, project code, job code

20. Payment / Invoice Audit Trail by supplier showing details of supplier number, supplier name, area, agent, reference number and amount

21. Listing of supplier transactions showing total bills received from supplier and payment issued

22. Yearly Purchase Report by Supplier, select by supplier code, date, area, agent

23. Summary of Yearly Purchase Report, select by supplier code, date, area,

agent

24. Listing of Top 50 Suppliers, select by date

25. List of Post Dated Cheque Issued to supplier that have no clear

Foreign Currency Reports

1. General Ledger Report in difference foreign currency, select by Account code, date, currency code

2. Print Customers / Suppliers Statement showing current transaction, amount and aging analysis in foreign currency, select by customer/supplier code, agent, area

3. Summary / Detail Aging Report for Customers / Suppliers in foreign Currency, select by customer / supplier code, agent, area, currency code, project code, job code

4. Customers / Suppliers Gain & Loss Report, select by payment date, customer/ supplier code

5. Updated Gain & Loss to Accounting System

6. Print Overdue Letter to the customer whose account is overdue in difference currency rate

7. Trial Balance report for all ledger account, Debtor balance or Creditor balance in different currency rate, select account code, project code, job code, currency code

8. Unrealised Gain & Loss Report for Debtor / Creditor / General Ledger

Transaction

1. Organise Journals according to accounting needs by creating the journal numbers and respective details.

2. Generate a new journal title quickly and conveniently by:

    ° Define the monthly journal titles sequence and starting month of journal title generation

    ° Generating the monthly journal titles in the sequence defined earlier

3. Enter daily accounting transactions into journals. The system will then automatically update all transactions instantly to ledgers and produce a financial report.

4. View and print all transaction in a Journal

5. Print a summary report of journals

6. Scan journal to check that transactions in each journal have been input correctly, and list the status of each journal

7. Applythe invoices / bills while entering the transaction and another method some user needs to apply the outstanding bills after entering the transaction or few days laters

GL REPORTS

1. General Ledger

2. Customers / Suppliers control Account

3. Debtor Ledger

4. Creditor Ledger

5. Trial Balance

6. AR Balance

7. AP Balance

8. Note of Account report for all ledger account to check the accuracy of transaction

9. Financial Report:

    ° Profit & Loss Account (14 formats)

    ° Expenses 12 months

    ° Monthly P&L A/C - By Project

    ° P&L A/C - This Year Only

    ° P&L A/C - 12 Months

    ° P&L A/C - This Year This Month

    ° P&L A/C - 2 Columns

    ° P&L A/C - Last Year This Year

    ° P&L A/C - Last Year This Month / This Year This Month

    ° P&L A/C - Last Month / This Month / Last Year / This Year

    ° P&L A/C - By Job

    ° P&L A/C - Last Month This Month

    ° Monthly Project Expenses

    ° P&L A/C - By Project

    ° P&L A/C - Quarterly

    ° Balance Sheet (6 formats)

    ° Balance Sheet - Current Month This Year

    ° Balance Sheet - By Project

    ° Balance Sheet - This Year Only

    ° Balance Sheet - 12 Months

    ° Balance Sheet - Last Year This Year

    ° Balance Sheet - 3 Columns

    ° Manufacturing Account (10 formats)

    °Manufacturing Account

    ° Manufacturing A/C - 12 months

    ° Manufacturing A/C - Last Year This Year

    ° Manufacturing A/C - Last Month This Month

    ° Manufacturing P&L A/C - This Year Only

    ° Manufacturing P&L A/C - 12 months

    ° Manufacturing P&L A/C - This Month This Year

    ° Manufacturing P&L A/C - Last Month This Month Last Year This Year

    ° Manufacturing P&L A/C - Last Year This Year

    ° Manufacturing P&L A/C - Last Month This Month

    ° Budget & Variance Report (3 formats)

    ° Budget - Monthly Report

    ° Budget - P&L A/C

    ° Budget - Monthly / Yearly Report

10. Consolidated Account

    ° Consolidated A/C - Balance Sheet

    ° Consolidated A/C - P&L A/C

11. Cash / Bank Book detail

12. Cash Flow Statement

13. Maintain Bank Reconciliation statement by marking transaction in bank account against the bank statement, and thereafter list out the unmark transaction

    ° Enter Last Accounting Year Transactions that were carried forward from last accounting year

    ° Mark Last Accounting Year Transaction that were carried forward last accounting year against your bank statement

    ° Remove last accounting year marked transaction for all cleared bank accounts transactions from last accounting period

    ° Mark this accounting year transaction for all cleared bank accounts transactions of this accounting year against your bank statement

    ° Print Bank Reconciliation Statements

14. Project Report

    ° Project Ledger

    ° Project Summary / Job Summary showing month-to-date and yearto- date accumulative figure of a project account. i.e. Sales Account or Purchase Account

    ° Project Profit Margin / Job Profit Margin showing income, cost, gross, expenses and net figure of a project / job account

15. Depreciation & Net Books Value for Fixed Assets Report select by account code

16. Gain/Loss on Disposal of Fixed Assets Report

17. Chart of Account select by account code or account type

18. Currency Rates Listing

19. Opening Balance Listing

20. Print Payment Voucher whenever there is a payment made, select by date, voucher number

21. Print Cheque select by date, cheque number

22. Sales and Commission Listing based on applied invoice select by date, agent, reference number, project

23. Sales & Service Tax Report in Details for

    ° List Standard Rated Sales

    ° List Exempt Sales

    ° List Zero-rated Sales

    ° List Out of Scope Sales

    ° List Taxable Purchases

    ° Mark / Unmark GST

    ° List Major Exports Scheme

    ° List Zero-rated Purchase

24. GST Form 5

Housekeeping

1. System setup for Company Profile, Financial Year, Customers / Suppliers Control Account & GST setting

2. Determine the format setting for Payment Voucher, Official Receipt, Customer Statement, Suppliers Remittance Advice, Print Cheque, Print Overdue Letter, Foreign Currency Debtor / Creditor Statement, General Journal, Foreign Currency Overdue Letter, Debit Note & Credit Note for Debtor / Creditor

3. Recover all data files after an interruption of power failure

4. Reorganize index files or remove marked files.

5. Rearrange transaction number if the number is not in sequence after deleting a transaction

6. Remove the paid bill so that the paid bill is not on the applied open invoice statement for Debtor and creditor

7. Recover the paid bill of Debtor or Creditor after remove the paid bill

8. After the year end, the system will purge away the transaction and provide the opening balance

9. Backup / Restore Data File or Report Format

10. Generate sample Chart of Account

11. Transfer transaction if the user enters the transaction in the wrong journal

System Administrator

1. Set User ID and Password, and the permission group

2. Allows the authorised person to check the password for each user and the last time the password was changed

3. Allows the authorized person to set group permission for users who belong to the same group

4. Track a users field data changes, record additions and deletions

5. Print the Audit Trail for checking purposes

6. Clear all the Audit Trail

7. Track the error made during the usage of Accounting System

8. Print Error List for checking purposes

9. Clear all the Error List

10. Allow to Change Account code, Project Code and Job Code