Data Migration and Initial Setup: Difference between revisions
No edit summary |
No edit summary |
||
Line 7: | Line 7: | ||
# Update Company Information: | # Update Company Information: | ||
## Navigate to Setup > Company Setup to ensure your company's information is up to date. | ## Navigate to Setup > Company Setup to ensure your company's information is up to date. | ||
# Create Bank Accounts: | # Create Bank Accounts: | ||
## Create bank accounts for GL bank and cash accounts. | ## Create bank accounts for GL bank and cash accounts. Go to Finance Mgt, | ||
# Manage Foreign Currencies: | # Manage Foreign Currencies: | ||
## If using foreign currencies, add them with at least one exchange rate dated earlier than the last transaction. | ## If using foreign currencies, add them with at least one exchange rate dated earlier than the last transaction. | ||
# | ## It can be performed by going to Finance Mgt, Maintenance, Add or Edit Foreign Currencies and Update Exchange Rates Tables. | ||
## | # Create GL Accounts: | ||
## | ## Go to Finance Mgt, Maintenance, Click on GL Chart of Accounts to add, edit, or delete accounts as necessary. | ||
# Create Master Records: | |||
## Customer Master. | |||
## Supplier Master. | |||
## Inventory item codes and producct descriptions. | |||
Note: Highnix could provide the migration of data for Items 4 and 5 at a fee or free depending on the package. Please reach out to the sales representative for the arrangement. | |||
=== Transferring Open Balance and Open Invoices to Highnix ERP: === | === Transferring Open Balance and Open Invoices to Highnix ERP: === | ||
# | # Preparatoin for transfer: | ||
## Print the Balance Sheet/Trial Balance from | ## Print the Balance Sheet/Trial Balance from your old system or request it from your Accountant. | ||
## Create a new Fiscal Year that precedes the current one. | ## Create a new Fiscal Year that precedes the current one. | ||
## Set the company to use this new fiscal year. | ## Set the company to use this new fiscal year. | ||
## Check and create GL accounts in the new system as per the old Balance Sheet. | ## Check and create GL accounts in the new system as per the old Balance Sheet. | ||
# Identify Open Invoices: | # Identify Open Invoices: | ||
## List all open invoices in the | ## List all open invoices in the old ERP system. | ||
# Trial Balance Inclusion: | # Trial Balance Inclusion: | ||
## Include open invoice amounts in relevant accounts when preparing the trial balance. | ## Include open invoice amounts in relevant accounts when preparing the trial balance. | ||
# Journal Entry for Closing Balances: | # Journal Entry for Closing Balances: | ||
## In Highnix ERP, create a journal entry to transfer closing balances, now becoming open balances. | ## In Highnix ERP, create a journal entry to transfer closing balances of old system, now becoming open balances of the new Highnix ERP system. | ||
## Enter the trial balance items ensuring Debits equal Credits for Asset, Liabilities, Income, and Equity. | ## Enter the trial balance items ensuring Debits equal Credits for Asset, Liabilities, Income, and Equity. | ||
# Retain Reference Copy: | ## Retain Reference Copy: Print a copy in PDF or Excel for future reference after Journal Entry is completed. | ||
# Enter Sub-ledger (Outstanding Invoices): | # Enter Sub-ledger (Outstanding Invoices): | ||
## Enter only open invoices, excluding closed items within an invoice. | ## Enter only open invoices, excluding closed items within an invoice. | ||
# Reconciliation: | # Reconciliation: Reconcile open invoices in the new system against records from the old system | ||
## After the open sub-ledgers invoices are entered, make adjustment if needed: Make adjustments to the values of the AP/AR accounts by select the Journal Entry entered in step 4. | |||
## | |||
# Retain Records: | # Retain Records: | ||
## Keep a record of the steps and adjustments made during this process. | ## Keep a record of the steps and adjustments made during this process in case the data need to be reviewed. | ||
# Set Normal Fiscal Year: | # Set Normal Fiscal Year: | ||
## Set the company's fiscal year back to its normal setting. | ## Set the company's fiscal year back to its normal setting. | ||
# Consult with Accounting Experts: | # Consult with Accounting Experts: It's advisable to consult with accounting professionals for guidance tailored to your specific situation. | ||
# | |||
# | |||
# | |||
# | |||
# Goto Setup, Company Setup to update your company's information. | # Goto Setup, Company Setup to update your company's information. | ||
# Goto Banking and General Ledger, GL Account and add, edit or delete GL Accounts as necessary. | # Goto Banking and General Ledger, GL Account and add, edit or delete GL Accounts as necessary. |
Revision as of 17:24, 16 February 2024
When A New Accounting System Is Setup, How Do I Start To Use the System and How To Transfer My Account Balance From My Old System To The New One?
Ans: When a new system is setup for you or your company, you should perform the following steps:
Setting Up New Highnix ERP System:
- Update Company Information:
- Navigate to Setup > Company Setup to ensure your company's information is up to date.
- Create Bank Accounts:
- Create bank accounts for GL bank and cash accounts. Go to Finance Mgt,
- Manage Foreign Currencies:
- If using foreign currencies, add them with at least one exchange rate dated earlier than the last transaction.
- It can be performed by going to Finance Mgt, Maintenance, Add or Edit Foreign Currencies and Update Exchange Rates Tables.
- Create GL Accounts:
- Go to Finance Mgt, Maintenance, Click on GL Chart of Accounts to add, edit, or delete accounts as necessary.
- Create Master Records:
- Customer Master.
- Supplier Master.
- Inventory item codes and producct descriptions.
Note: Highnix could provide the migration of data for Items 4 and 5 at a fee or free depending on the package. Please reach out to the sales representative for the arrangement.
Transferring Open Balance and Open Invoices to Highnix ERP:
- Preparatoin for transfer:
- Print the Balance Sheet/Trial Balance from your old system or request it from your Accountant.
- Create a new Fiscal Year that precedes the current one.
- Set the company to use this new fiscal year.
- Check and create GL accounts in the new system as per the old Balance Sheet.
- Identify Open Invoices:
- List all open invoices in the old ERP system.
- Trial Balance Inclusion:
- Include open invoice amounts in relevant accounts when preparing the trial balance.
- Journal Entry for Closing Balances:
- In Highnix ERP, create a journal entry to transfer closing balances of old system, now becoming open balances of the new Highnix ERP system.
- Enter the trial balance items ensuring Debits equal Credits for Asset, Liabilities, Income, and Equity.
- Retain Reference Copy: Print a copy in PDF or Excel for future reference after Journal Entry is completed.
- Enter Sub-ledger (Outstanding Invoices):
- Enter only open invoices, excluding closed items within an invoice.
- Reconciliation: Reconcile open invoices in the new system against records from the old system
- After the open sub-ledgers invoices are entered, make adjustment if needed: Make adjustments to the values of the AP/AR accounts by select the Journal Entry entered in step 4.
- Retain Records:
- Keep a record of the steps and adjustments made during this process in case the data need to be reviewed.
- Set Normal Fiscal Year:
- Set the company's fiscal year back to its normal setting.
- Consult with Accounting Experts: It's advisable to consult with accounting professionals for guidance tailored to your specific situation.
- Goto Setup, Company Setup to update your company's information.
- Goto Banking and General Ledger, GL Account and add, edit or delete GL Accounts as necessary.
- Transfer the Balance Sheet's balances from the old system to the new Highnix ERP system:
- Print out the Balance Sheet/Trial Balance from your old system or ask your Accountant to generate a Balance Sheet/Trial Balance that ends your existing accounting system. In Singapore, many SMEs or Micro Enterprises outsource their book keeping or accounting to 3rd party accounting service providers. These parties should be able to generate the balance sheet/Trial Balance for your company's account.
- Goto setup, Fiscal Years, Create a Fiscal Year that is one year before the one you created when you started. (For example, if your Fiscal year started January 1, 2023, create a fiscal year starting January 1, 2022.)
- Goto setup, Set the Company to use this year in Company Setup.
- Go to Banking and General Ledger, check if you have all the same GL accounts in the new system as the ones listed on your Balance Sheet from your old accounting system. If they do not all exist in the GL List, then create them.
- Create Bank Accounts for your GL bank accounts and Cash accounts. Write them down so you can easily find them later.
- If you use foreign currencies, you need to add the foreign currencies and with at least one exchange rate with the date earlier than the last transactions. You can access these under the Finance Mgt tab.
- Go into Journal Entry in Banking and General Ledger. Set the date to be the last of the year (e.g. December 31).
- Enter the lines from the Balance Sheet one by one. Enter Asset as Debit, Liabilities, Income and Equity (Capital) as Credit, You should end up with DEBIT total equal to the CREDIT total or zero difference because the debits and credits should equal on your Balance Sheet.
- If you are transfering the account balances from your old Accounting/ERP system with open invoices to Highnix ERP system, you can follow these steps:
- Identify Open Invoices:
- List all open invoices in your existing ERP system.
- Record in Trial Balance:
- Include the open invoice amounts in the relevant accounts when preparing the trial balance.
- Create a Journal Entry:
- In the new Highnix ERP system, create a journal entry to transfer the closing balances (it will become the open balances of the new system).
- Enter the lines in the trail balance one by one. If you use Balance Sheet, enter Asset as Debit, Liabilities, Income and Equity (Capital) as Credit, You should end up with DEBIT total equal to the CREDIT total or zero difference because the debits and credits should equal on your Balance Sheet.
- After every items are updated, print a copy in PDF or Excel format for retention. This copy of reference is very important when the next steps are performed.
- Enter the sub-ledger (outstanding Sales and Suppliers' invoices):
- Enter only the open invoices and ensure that closed items within an invoice are not entered.
- User may take times to enter the open invoices until they are completely entered.
- Reconcilation: Reconcile the open invoices in the new system against the original records from the old system.
- User may reconcile the open invoices entered as mentioned in section 9.4 by adjusting the value of the the AP/AR accounts back to the value as in section 9.3.2.
- This approach allows you to transfer balances accurately while keeping track of open invoices. It's advisable to consult with your accounting
- Identify Open Invoices:
- Set the normal Fiscal Year on the Company again and you are done.
If My System Is Installed On My Company's Server or PC, Can I Access The System If I Am At Home Or Travel? If So, How?
Ans: Yes, you can. There are some requirements you need to meet before you can setup the Remote Access. From user's standpoint, these requirements are very simple. They are:
- The hardware should be a Win7 or Win8 PC.
- The Server should have a connection to the Internet.
- You need to allow our technical support personnel to login to your Internet router to make some configuration.
Please contact our distributor/Value Added Reseller near you for technical support.
Data Backup. What If I Click the Backup Button More Than Once?
Ans: If you click the Backup Button more than one time within the same minute, you will most likely corrupt the backup database file. As the system will create the backup file with the name taken from the date, hour and minute, you should not click the "Create Backup" button more than once within the same minute. Otherwise, it will mess up the first back up file created under the same date, hour and minute.
The best way to do backup is to click the backup button once. If you need to create another backup file, wait for the next minute before you click on the backup button again.
How To Add Company's Logo?
Ans: You can add your company's logo and this logo will appear on the top left corner on your documents such as Sales Quotation, Sales Invoice, Purchase Order, Delivery Note...etc. To add your company's logo, please have your logo ready in jpg format. Use any graphic software to create your logo and save it in jpg format. The size may be around 2.5cm x 4cm. The software will automatically make some adjustment if it is bigger than the specific size.
Go to Setup, Company setup as shown.
Click on "Choose File" button and a pop up window will appear. Navigate to the folder where your logo file is located and choose that file and click on "Open". Then click on the "Update" button. That is it.