sage ubs accounting · sage ubs accounting sample report vivid solutions sdn bhd - 03-91722228 1...

Sage UBS Accounting Sample Report

VIVID SOLUTIONS SDN BHD - 03-91722228 www.vivid.com.my 1

Sage UBS

Accounting

Sample Report 1.0



Contents Chapter 1: Debtors ............................................................................................................................... 6

1.1: Chart of Account ....................................................................................................................... 6

1.2: Tax Code Maintenance.............................................................................................................. 6

1.3: Debtors Listing ........................................................................................................................... 7

1.4: Print Labels ................................................................................................................................ 7

1.5: Print Debtors Statement............................................................................................................ 8

1.6: Print Debtors Transactions ....................................................................................................... 9

1.6.1: Transaction Summary ........................................................................................................ 9

1.6.2: List Bills And Payments ..................................................................................................... 9

1.6.3: List By Account And Description .................................................................................... 10

1.7: Print Debtors Aging ................................................................................................................. 11

1.8: Print Sales Analysis ................................................................................................................. 12

1.8.1: Year Sales Report ............................................................................................................. 12

1.8.2: Top 50 Customers ............................................................................................................. 12

1.8.3: Agent Commission Listing ............................................................................................... 13

1.9: Print Receipt ............................................................................................................................ 13

1.10: Open Item Menu Debtors ..................................................................................................... 14

1.10.1: List Unpaid Bills ............................................................................................................. 14

1.10.2: Print Details Aging ......................................................................................................... 15

1.10.3: Commission Payment Listing ........................................................................................ 16

1.10.4: Print Due Date Invoices .................................................................................................. 17

1.10.5: Print Overdue Invoices ................................................................................................... 17

1.10.6: Print Sales & Collection ................................................................................................. 17

1.10.7: Print Debtor Paid Invoices ............................................................................................. 18

Chapter 2: Creditor ............................................................................................................................ 19

2.1: Creditor Listing ....................................................................................................................... 19

2.2: Print Label................................................................................................................................ 19

2.3: Print Remittance Advice ......................................................................................................... 20

2.4: Print Creditors Transaction ................................................................................................... 20

2.4.1: Transaction Summary ...................................................................................................... 20

2.4.2: List Bills And Payments ................................................................................................... 21

2.4.3: List By Account And Description .................................................................................... 21



2.5: Print Creditors Aging .............................................................................................................. 22

2.6: Print Purchase Analysis .......................................................................................................... 23

2.6.1: Year Purchases Report ..................................................................................................... 23

2.6.2: Top 50 Suppliers ............................................................................................................... 23

2.7: Open Item Menu Creditors..................................................................................................... 24

2.7.1: List Unpaid Bills ............................................................................................................... 24

2.7.2: Print Details Aging ........................................................................................................... 24

2.7.3: Commission Received Listing .......................................................................................... 25

2.7.4: Print Due Date Invoice ..................................................................................................... 25

2.7.5: Print Overdue Invoice ...................................................................................................... 26

2.7.6: Print Payment Vouchers .................................................................................................. 26

Chapter 3: Transaction ...................................................................................................................... 27

3.1: Print Batch Of Transaction .................................................................................................... 27

3.2: Print Batch Summary ............................................................................................................. 28

3.3: Scan Batches ............................................................................................................................. 29

3.4: Open Item Menu Debtor ......................................................................................................... 30

3.4.1: Maintain B/F Bills ............................................................................................................. 30

3.4.3: Reverse Bills ...................................................................................................................... 31

3.4.4: Edit B/F or O/l ................................................................................................................... 31

3.4.5: Bill Payment Ledger ......................................................................................................... 32

(a) View Bill Payment Ledger .................................................................................................... 32

(b) Edit Bill Opening Balance .................................................................................................... 33

(c) Check Duplicated Glpost Entry No. .................................................................................... 33

3.6: Open Item Menu Creditors..................................................................................................... 34

3.6.1: Maintain B/F Bills ............................................................................................................. 34

3.6.2: Reverse Bills ...................................................................................................................... 34

3.7: GST Bad Debt Journal (AR) .................................................................................................. 35

3.7.1: Bad Debt Relief ................................................................................................................. 35

3.8: GST Bad Debt Journal (AP) ................................................................................................... 36

3.8.1: Output Tax Adjusment (Refund Customs) .................................................................... 36

Chapter 4: Reports ............................................................................................................................. 37

4.1: View Ledgers ............................................................................................................................ 37

4.2: Print Ledgers ............................................................................................................................ 37



4.3: Trial Balance ............................................................................................................................ 38

4.4: Profit & Loss Account ............................................................................................................. 39

4.5: Balance Sheet ........................................................................................................................... 40

4.6: Print A Group .......................................................................................................................... 41

4.7: Fixed Assets .............................................................................................................................. 41

4.8: Cash Flow Statement ............................................................................................................... 42

4.9: Good And Service Tax ............................................................................................................ 43

4.9.1 : View Tax Totals ............................................................................................................... 43

4.10: Malaysia GST ......................................................................................................................... 44

4.10.1 : Goods And Service Tax Report .................................................................................... 44

4.10.2 : GST Return Wizard ...................................................................................................... 45

4.10.3 : Lampiran 2 ..................................................................................................................... 46

4.11: Check GST Transaction Code .............................................................................................. 46

4.12: Check VAT Sales Entry ......................................................................................................... 47

4.13: Check VAT Purchase Entry ................................................................................................. 47

4.14: Project Report ........................................................................................................................ 48

4.14.1 : Project Ledger ................................................................................................................ 48

4.14.2 : Project Summary ........................................................................................................... 48

4.14.3 : Project Job Summary .................................................................................................... 48

4.14.4 : Project % Profit ............................................................................................................. 49

4.14.5 : Receipt & Payments Account ....................................................................................... 49

4.14.6 : Create Project Job Balance File ................................................................................... 50

4.14.7 : Project and Job Entries ................................................................................................. 50

4.15: More Report (1) ..................................................................................................................... 51

4.15.1: View Graph ..................................................................................................................... 51

4.15.2: Check Transaction .......................................................................................................... 52

4.15.3: Bank Reconciliation Statement ..................................................................................... 52

4.15.4: Payment Vouchers .......................................................................................................... 53

4.15.5: Print Receipt.................................................................................................................... 53

4.15.6: Print Cheque ................................................................................................................... 54

4.15.7: Transaction Summary ................................................................................................... 54

4.15.8: Print P&L for 12 Months ............................................................................................... 55

4.15.9: Budget & Variance ......................................................................................................... 56



4.15.10: Consolidated Account ................................................................................................... 57

4.15.11: Print Overdue Letter .................................................................................................... 58

4.16: More Report (2) ..................................................................................................................... 58

4.16.1: Generate Voucher Sequence .......................................................................................... 58

4.16.2: Print Transaction Voucher ............................................................................................ 59

4.16.3: Batch Main Account Transaction Summary ................................................................ 59

4.16.4: Month Main Account Transaction Summary .............................................................. 60

4.16.5: Main Account Month Balance ....................................................................................... 61

4.16.6: Trail Balance (2) ............................................................................................................. 62

4.16.7: Trail Balance (3) ............................................................................................................. 63

4.16.8: Multi Column Report ..................................................................................................... 63

4.16.9: Bank Service Provider’s Bank List ............................................................................... 64

Chapter 5: Periodic ............................................................................................................................. 65

5.1: View Audit Trail ...................................................................................................................... 65

5.2: GST Audit File ......................................................................................................................... 65

5.2.1: GAF Generator ................................................................................................................. 65

5.2.2: Bill Listing ......................................................................................................................... 66

5.3: Partial Exemption Apportionment ........................................................................................ 66

5.4: Capital Goods ........................................................................................................................... 67

5.4.1: Maintain Capital Goods ................................................................................................... 67

Chapter 6: Housekeeping ................................................................................................................... 68

6.1: GST-03 Verification ................................................................................................................ 68

6.2: Transaction Type Tag ............................................................................................................. 69



Chapter 1: Debtors 1.1: Chart of Account

1.2: Tax Code Maintenance



1.3: Debtors Listing

1.4: Print Labels



1.5: Print Debtors Statement



1.6: Print Debtors Transactions

1.6.1: Transaction Summary

1.6.2: List Bills And Payments



1.6.3: List By Account And Description



1.7: Print Debtors Aging



1.8: Print Sales Analysis

1.8.1: Year Sales Report

1.8.2: Top 50 Customers



1.8.3: Agent Commission Listing

1.9: Print Receipt



1.10: Open Item Menu Debtors

1.10.1: List Unpaid Bills



1.10.2: Print Details Aging



1.10.3: Commission Payment Listing



1.10.4: Print Due Date Invoices

1.10.5: Print Overdue Invoices

1.10.6: Print Sales & Collection



1.10.7: Print Debtor Paid Invoices



Chapter 2: Creditor 2.1: Creditor Listing

2.2: Print Label



2.3: Print Remittance Advice

2.4: Print Creditors Transaction




2.4.2: List Bills And Payments

2.4.3: List By Account And Description



2.5: Print Creditors Aging



2.6: Print Purchase Analysis

2.6.1: Year Purchases Report

2.6.2: Top 50 Suppliers



2.7: Open Item Menu Creditors

2.7.1: List Unpaid Bills

2.7.2: Print Details Aging



2.7.3: Commission Received Listing

2.7.4: Print Due Date Invoice



2.7.5: Print Overdue Invoice

2.7.6: Print Payment Vouchers



Chapter 3: Transaction 3.1: Print Batch Of Transaction



3.2: Print Batch Summary



3.3: Scan Batches



3.4: Open Item Menu Debtor

3.4.1: Maintain B/F Bills

3.4.2: Check Bills



3.4.3: Reverse Bills

3.4.4: Edit B/F or O/l



3.4.5: Bill Payment Ledger

(a) View Bill Payment Ledger



(b) Edit Bill Opening Balance

(c) Check Duplicated Glpost Entry No.



3.6: Open Item Menu Creditors

3.6.1: Maintain B/F Bills

3.6.2: Reverse Bills



3.7: GST Bad Debt Journal (AR)

3.7.1: Bad Debt Relief



3.8: GST Bad Debt Journal (AP)

3.8.1: Output Tax Adjusment (Refund Customs)



Chapter 4: Reports 4.1: View Ledgers

4.2: Print Ledgers



4.3: Trial Balance



4.4: Profit & Loss Account



4.5: Balance Sheet



4.6: Print A Group

4.7: Fixed Assets



4.8: Cash Flow Statement



4.9: Good And Service Tax 4.9.1 : View Tax Totals



4.10: Malaysia GST

4.10.1 : Goods And Service Tax Report



4.10.2 : GST Return Wizard



4.10.3 : Lampiran 2

4.11: Check GST Transaction Code



4.12: Check VAT Sales Entry

4.13: Check VAT Purchase Entry



4.14: Project Report

4.14.1 : Project Ledger

4.14.2 : Project Summary

4.14.3 : Project Job Summary



4.14.4 : Project % Profit

4.14.5 : Receipt & Payments Account



4.14.6 : Create Project Job Balance File

4.14.7 : Project and Job Entries



4.15: More Report (1)

4.15.1: View Graph



4.15.2: Check Transaction

4.15.3: Bank Reconciliation Statement



4.15.4: Payment Vouchers

4.15.5: Print Receipt



4.15.6: Print Cheque




4.15.8: Print P&L for 12 Months



4.15.9: Budget & Variance



4.15.10: Consolidated Account



4.15.11: Print Overdue Letter

4.16: More Report (2)

4.16.1: Generate Voucher Sequence



4.16.2: Print Transaction Voucher

4.16.3: Batch Main Account Transaction Summary



4.16.4: Month Main Account Transaction Summary



4.16.5: Main Account Month Balance



4.16.6: Trail Balance (2)



4.16.7: Trail Balance (3)

4.16.8: Multi Column Report



4.16.9: Bank Service Provider’s Bank List



Chapter 5: Periodic 5.1: View Audit Trail

5.2: GST Audit File

5.2.1: GAF Generator



5.2.2: Bill Listing

5.3: Partial Exemption Apportionment



5.4: Capital Goods

5.4.1: Maintain Capital Goods



Chapter 6: Housekeeping 6.1: GST-03 Verification



6.2: Transaction Type Tag

sage ubs accounting · sage ubs accounting sample report vivid solutions sdn bhd - 03-91722228 1...

Documents