Common FAQ
Bank Recon previous reconciled balance does not tally
The Previous reconciled balance field is a calculated field base on the sum of the previous presented documents. when this field does not tally, and there is no red color document to indicate a change in value what commonly happen is a presented ...
Email Function Guide
Required Setup to use email function. Sender Information (Your Information) To configure the sender information, you need to have the sysadmin role. in the top menu bar tools -> email setting the 2 options are document and SOA. document is for all ...
Default Setting
Default Setting module is located at Setup > Company Details. Each document type has a set of fields which are eligible for default setting, meaning that users may set those fields to automatically contain a specific number value, text value or tick; ...
Hiding rows with zero quantity
Click on Layout button to open Document Properties page. Default Query should be "Standard", which displays all rows in the document printout/preview. To hide rows with zero quantity, uncheck the Default checkbox, and select "Hide 0 Quantity", and ...
Using the date function
The date field allows you to type a date or select a date through the drop down. Method 1 typing the date. you can click on the data part that you want to change and directly type the day/month/year. Method 2 Using the Selection method you can use ...
Document Time Sorting Options
The system has context menu option in that appear for different modules. For sorting we have item sorting and account sorting. There is one more option for sorting but it is not a document time sorting option and this is BP sorting. Item sorting In ...
Business Partner Setup
The Business Partner Registration module is where the company's Business Partners (and their details) should be registered. "Business Partners" is a term which encompasses companies who have either of these relationships with your company: as a ...
Payment Terms
Go to Setup > Customer/Vendor > Payment Terms and click "New" (or "Duplicate"). The value inputted in fields "Month" and "Day" will determine the length of this Payment Term. If you select "Invoice Date" under Base, each document's Due Date will be ...
Password Reset
If you need to assist a user who has forgotten their password, follow the steps below. Navigate to Maintenance > Access Control > User (Cross Company) and identify the registration which belongs to that user. Note: If you are unable to navigate to ...
Delete Business Partner
To remove a Business Partner registration that was just created and have not been used for any entries or setup, simply use the "Delete" button at Business Partner Registration module. Note: The loading time for deleting a Business Partner ...
Backdating running number.
If you need to get back dated running numbers, you can do the following. E.g. Current date is Jan 2020. I need to enter documents in Dec 2019. This is my current running number set. Notice the "[YY]"? This is the year portion; currently in the ...
How to Export Reports
The Reporting system has 3 main formats for export. PDF Excel CSV However not all modules have the CSV export function. See steps below on how users can export reports in each format. Export to PDF This export method is available for all reports and ...
Creating a user Login account
Go to Maintenance > Access Control > User (Cross Company) and create a new User, assign the relevant Role(s). Login Id is the "username" which the new user has to enter along with Password during login. Name is the name of the user; useful for ...
Creating a new Role and Login account
Go to Maintenance > Access Control > Roles (Cross Company) and create a new Role. "Read" allows the user to open that module, view the document details, and generate the report on the table. "New" allows the user to create new document or entries on ...
How do I enter a discounted sale price scheme entry
For this example please reference IRAS example. https://www.iras.gov.sg/taxes/goods-services-tax-(gst)/general-gst-schemes/discounted-sale-price-scheme You sold a motor vehicle at $25,000 (excluding GST) on 5 Jan 2023. GST chargeable = $25,000 x 50% ...
Intercompany Trading Setup for Balance Sheet / Trial Balance
This setup for for companies that: participate in trading within its own group of companies (subsidiaries, sister company, parent organisation etc.), and need to generate Balance Sheet and Trial Balance reports that separate Debtor and Creditor ...
Bank Loan
Scenario: You loan 100,000 from bank. there is also a monthly payment with interest. To begin we will need an account to hold the loan amount. we will also need an expense account to hold the interest value. you'll need to create the accounts if you ...
Excel convert text to numbers
To convert a text to number. you can click on the yellow exclamation and choose convert to number. this process can be applied to multiple rows at the same time.
How do I enter dividend?
For dividend processing we do the following. set aside the value into a dividend account. next a approved amount will be taken from the dividend account and moved to a dividend payable account. finally payment is made against this dividend payable ...
Edit columns of document table
Right-click on any column header of your document table. Click "Edit Column". The column header row will turn grey. When the header row is grey in colour, users may: 1. Resize the length of each column. Click and drag the borders of each column ...
Troubleshooting improper Trade Debtor/Creditor entries (Aging).
Understanding the different Aging reports. Standard Aging Reports the standard aging reports only includes properly created entries. a proper entry is a entry a entry that affected a trade debtor/creditor account that has a BP code and document ...
Resizing Letterhead/Footer images
The standard document layout uses images for the letterhead and footers. Sometimes these images can be a few hundred KB in size. these large image will contribute to the generated PDF size. Note if you are printing physical documents reducing the ...
GST Rounding option
By default, the system calculates the GST Amount of each line item before summing up each line item's GST Amount to form the Document total GST Amount. (The figure displayed in "7% GST" field of the document) If you would like to change how a ...
How to enable selecting Account for Supplier Invoice
The following guide will help you if you are facing a problem that does not allow you to select an Account after selecting an Item in the Supplier Invoice section. (Do note that the Account column will be available for manual selection, but not as an ...
Improper knock off
Improper knock off occurs when using the Journal Entry module and the entries are improperly created. Sample of incorrect entry. the Trade Debtor row has a Business Partner selected but no document is selected. With no document specified, this ...
Off-Setting Sales Invoice with Credit Note
Off-Setting Sales Invoice with Credit Note Location Action Remark SALES> RECEIPT Click SALES activity Click RECEIPT module Click NEW CUSTOMER select EveryDay Customer Pte Ltd Click IMPORT Click DOCU OUTSTANDING Click ADD ALL ROWS You ...
Issue a Credit Note
3.1.4.1 Issue a Credit Note Location Action Remark SALES> CREDIT NOTE Click SALES activity Click CREDIT NOTE module Click NEW CUSTOMER select EveryDay Customer Pte Ltd S/N enter 1 ITEM select SVC001 DESCRIPTION amend to You may amend ...
Over-payment and advance payment.
Both Receipt and payment module have the feature. the example will be base on the the payment module. Common scenario where you would use the function is when you have to make a payment before the invoice is received. , when there is a over-payment. ...
How do I reflect the deposit in Customer Invoice (Alternative method)?
Note: The following method is not recommended and is only shown as an alternative. Step 1. create a Chart of account to hold the deposit value. Click SETUP Activity Click ACCOUNTS menu. Click CHART OF ACCOUNTS. Click NEW button. See details above ...
Changing my Item's default posting
When you need an item to post to a specific account you can create up an item group to specify the posting. In the following example, i want to post to rental account whenever i choose the rental account. Under Setup -> Item details -> Item Group ...
Revaluation of Foreign Currency accounts
During the normal course of transactions Foreign currency accounts accounting values may not not match your book rate. Doing a revaluation will set back the accounting value to match your book rate. In the system you can use the Unrealised Exchange ...
Update Report Document Settings
Update Standard ReportsStep 1 Click MAINTENANCE -> UPDATES -> REPORT SYSTEM IMPORT Step 2 Click Button GET REPORT Un-tick 'Delete Existing SYSTEM Reports Step 3 Click Button UPDATE Click on the 'OK' message box when it appears. Document ...
How to enable Module Access by Roles (Cross Company)?
This is happen because some of the modules are added new to the OCi Accounting Software V10. To enable access to the Un-Available Module do the Following... Click the MAINTENANCE -> ACCESS CONTROL -> ROLES (CROSS COMPANY) Click over ...
How do I create an Invoice for items I have not received?
Scenario I want to create an Invoice while have not receive item yet. Solution We need to create a Receive Order in Purchases for input in the Inventory Item, then we just can create an Invoice to our customer. After this, we may need to import ...
How to Enter UnPresented Cheques into Openings?
Scenario How to enter UnPresented Cheques into Openings?Solution You can do it by creating a Opening GL entry from the Adjustment menu. Steps 1 To key in your Unpresented Chques from the last financial year into the physical year. For doing this ...
How to Key in Grant from IRAS
Scenario How can I Receive in the Grant from IRAS in to the OCi Accounting System Version 10Solution You can do it by creating a Income Account for doing this go and verify the Chart of Account first, if can not find then create a Income Account. ...
How do I Contra Payment for Future Transaction while Year End Closing
Scenario I have 2 Companies with same business partner, I had deal a sale transaction on 04/12/2012 and i got another deal as purchase on 15/01/2013 then i just directly use the receive to contra those transaction on 20/12/2013. After i done contra ...
How do I Show the Processing Fee for a Money Changer Transaction?
Scenario I need to withdraw USD in cash for my Petty Cash. My bank account is in USD and the money changer charges me a processing fee for converting my cheque into cash. I will need to transfer $1000 USD to my petty cash account in USD, and the ...
How do I Issue Staff Salary Payment?
Scenario How do I Issue Staff Salary Payment in OCi Accounting System Version 10Solution There are a few methods to go about doing it depending on your nature of business and how you want to make use of your chart of accounts. Here is one method. ...
Finding your PC's name
Open Windows File explorer. Right click on This PC click on Properties. Computer name is your PC's name the product ID and computer name will match the entry in the PCID administration
Next page