...
Note | ||
---|---|---|
| ||
The journal created is NOT the trial balance verbatim It IS a journal that is REQUIRED on the date of the upload to move the trial balance to the values uploaded. In essence - the journal created is the difference between the systems current trial balance - and the new target trial balance The retained earnings on the imported trial balance must be the same as the retained earnings in the system for the previous year (create the required journal if necessary) Remove "Retained Earnings" and remove "YTD earnings" as these are not GL accounts - they are calculated values in our system. Set ALL FX BANK ACCOUNT values to zero in your upload file AND in the system. The opening balance journal can only be AUD.
|
Columns required in the spreadsheet
...