TABLE OF CONTENTS
- Setup UOB Account
- Get Account Balance
- Creating Bank Rules
- Applying Bank Rules
- Import Bank Transactions
- Perform Bank Transactions Reconcile
- Perform payment from Payment Voucher
AutoCount Cloud Accounting is now integrated with UOB Account. You can now make use of this integration to perform the following:
- Perform payment from Payment Voucher
Setup UOB Account
To make use of these functions, you will need to setup your UOB Account in Cloud Accounting. As a requirement, you need to have UOB Business Account and able to login into UOB SME App. Follow the steps below to setup your UOB Account:
1. Login to your Cloud Accounting and click on the top right “Setting” icon > Bank Setting.
2. In the Bank Setting page, it will show all available integrated banks with Cloud Accounting. For UOB Account, click on the UOB Settings tab.
3. Key in your Business Registration Number at the field provided and click “Save”.
4. After that, switch over to your UOB SME App to link Cloud Accounting with your selected UOB Account.
- In Business Overview, scroll down and tap on “Link your account”
- Select a partner to see more details, then tap on “Link account”
- Follow the on-screen instructions to complete the linking process
5. Switch back to Cloud Accounting, you will see a new UOB Account record at the grid which you had updated from the apps just now.
6. Select the Bank Account Code (GL Code) in this company that you want to link with your UOB Account. This Bank Account must be in MYR currency for Malaysia company and SGD currency for SGD Company. Click “Save” once you are done.
*Currently we only support for local payment only.
Get Account Balance
You can get your UOB Account balance that you link in Cloud Accounting. Refer to the following steps on how to know your account balance from Cloud Accounting.
1. On the left Menu > Accounting > Bank Reconciliation or Bank Transactions.
2. At the top section, choose your bank account, in this case we will choose UOB Account that is linked.
3. You will notice a new button “Get UOB Account Balance” appear just right beside the bank account selection. Click on this button to get your account balance.
4. After this, a new dialog page will appear. Key in your credentials to proceed.
5. After login, the bank balance will then reflect at Cloud Accounting.
6. You can also see when your last updated balance. Besides, a “Update Balance” button is there for you to trigger the update when require. When you click on the button, you will need to key in your credentials to get your balance as Step 4.
Creating Bank Rules
Bank Rules help to ease the reconciliation process, so you do not need to manually create a new transaction every time you receive a recurring or the same type of bank transaction.
During the import process of bank transactions into Cloud Accounting, the system will help to check if it meets the conditions that you have set in the bank rules and proceed to assign the Acc. No. (GL code), Description and Journal Type.
To create Bank Rules, click on “+New” button.
Fields
Name: Key in your Bank Rules name.
Rules Type: Select the rule type between “Spend Money” or “Receive Money”.
Bank Account: Select to “Apply to all bank accounts” or “Apply to selected bank account(s)”.
If select “Apply to selected bank account(s)”, you can tick the banks you want to apply the bank rules.
Condition: Select the condition between “Description” , “Reference” or “Amount”.
Account : Select the GL code for Cash Book Entry detail lines.
Journal Type: Select the journal type.
Click “Save” to commit the changes once you have done keying in or editing the required information.
Applying Bank Rules
Bank Rules is applied when you import bank transactions. For example, below is an imported bank transaction of hire purchase which you pay to another party.
1. You can click on “Reconcile” button on the right side of the bank transaction.
2. You will be able to see the bank transaction is already assign with the bank rules that you had set. You can directly click “Save” if there is no amendment needed.
The bank transaction is successfully reconciled.
Import Bank Transactions
You can import bank transactions after you have link with Cloud Accounting. Refer to the following steps on how to import from UOB in Cloud Accounting.
1. Click on “+Import” > Import from UOB.
2. A small pop-up will show up for date selection. Select From Date and To Date needed and click on “Import”.
3. The bank transaction will display in the listing.
Perform Bank Transactions Reconcile
After import from UOB, you can proceed to perform reconcile for the bank transactions.
There is 2 scenario for Bank Transactions reconcile.
Scenario 1 : Create new Receipt Voucher or Payment Voucher
1. Click on “Reconcile” on the right side of the bank transaction you would like to reconcile.
2. A pop-up window will appear. Select “Create new receipt voucher” > Assign Acc. No.. You can also select the Journal Type and amend the Description as needed, then proceed to click “Save”.
3. You will be able to see the Status is changed to “Reconciled” with document number. You able to click and view the newly created Receipt Voucher.
Scenario 2 : Match with existing document
1. Click on “Reconcile” on the right side of the bank transaction you would like to reconcile.
2. A pop-up window will appear. Select “Match with existing document” > select existing transaction to match.
Note that the transactions must met below 2 condition only will appear in the listing :
- The voucher date must be earlier than or equal to the bank transaction date
- The amount must be the same as the bank transaction amount
* Invoice using Bank in "Payment Amount" will also show out in the listing for reconcile.
You also able to click on the document number to view transaction. Proceed to click “Save” after select.
3. You will be able to see the Status is changed to “Reconciled” with the existing document number.
Scenario 3 : Applying Bank Rules
Perform payment from Payment Voucher
You can now perform payment from Payment Voucher that you created in Cloud Accounting. There is no need to separately rekey and perform this process for the payment to proceed. Below are the steps and example on how you can perform a payment from Cloud Accounting.
1. First, set your supplier’s Bank Account. Go to Supplier page and create or edit a supplier.
2. Click on the “Others” tab. Key in the following details:
- Payment Type – Select the payment or which bank account that you usually use to pay this supplier. Example for this case “UOB Online Payment”.
- Bank Name – Select your supplier’s Bank.
- Bank Account No. – Key in your supplier Bank Account Number.
- Beneficiary Name – Key in your supplier’s payment Beneficiary Name.
3. Click “Save” once you had completed key in the required info. Repeat Step 1 and 2 to your other supplier if wish to use UOB Online Payment via Cloud Accounting.
4. Create a new Payment Voucher (Left Menu Accounting > Cash Book Entry > New Payment Voucher).
5. Key in your Payment Voucher details. To perform online payment via UOB, choose only UOB as your payment method (multi-payment not supported). Make sure the selected payment method is the one that link to UOB Account (check setup steps from previous section). Click “Save” when you are done.
6. After save, view the Payment Voucher from the Cash Book List.
7. Click or mouse over on the “Action” button and then click on the “Online Payment”.
8. A new page will load to show the summary of this payment. By default, the bank details will capture from what you had maintained in Supplier (Refer Step 1 and 2).
9. Click on the “Make Payment”. You will need to choose the Payment Type. Click “Submit” to submit your payment request. If you did not maintain the bank details for your supplier or you are paying to a non-supplier (such as utility expenses), you can key in the bank details at this dialog box for “Pay to Bank”, “Pay to Account” and “Beneficiary Name”.
10. After submit payment, it will direct you to your UOB SME App to complete your payment. If your payment is not completed through the apps, it will deem as no payment has been made to your supplier.
*You can only check your payment status at UOB side, AutoCount Cloud Accounting will not have the authorization to check through your bank payments.
11. For more information on UOB SME App, please refer below:
Malaysia: https://www.uob.com.my/business/digitalise/uob-sme.page
Singapore: https://www.uob.com.sg/business/digitalise/business-app.page