Acumatica

1.        Tips on your budget data:

       Income statement

• All income and expense budget amount must be imported as only the value no negative values.
• Exceptions: 
• negative income is shown with a - (minus)
• negative expense is shown with a - (minus)        

Balance sheet

• All assets, liabilities and equity budget amounts must be imported as only the value no negative values.
• Exceptions:
• negative asset is shown with a - (minus)
• negative liability is shown with a - (minus)
• negative equity is shown with a - (minus)

2.        Export the currency COA this will show the account type of each gl account.

3.        Use your wisERP budget and copy paste only column with budget amounts to a new sheet.

4.        Add a matching sheet with wisERP gl account and Acumatica gl accounts.

5.        Add your Acumatica accounts with the look and also add the acumatica type of account from you COA.

6.        Make sure that your total sum of all the values is still ZERO.

7.        Now make a new sheet below and add formules to copy your amounts from the sheet with applying the exception rules above.

8.        When you work with sub-accounts make sure that you only have only line item per sub account.

Created with the Personal Edition of HelpNDoc: Easily create EBooks