...
| Note |
|---|
| title | Retained Earnings line is not required from the trial balance |
|---|
|
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. |
| Note |
|---|
|
Set ALL FX BANK ACCOUNT values to zero in your upload file AND in the system. The opening balance journal can only be AUD. - Check the balance sheet has AUD value = zero for all FX bank accounts in our system
- In your trial balance upload - Put the AUD value of FX accounts into any non FX GL account in the upload
- After the upload do a "Transfer to FX bank account" to move the AUD into the FX bank account and revalue it to the FX rate at the start of operation.
|
| Note |
|---|
| title | Accounts Receivable and Accounts Payable |
|---|
|
Any Journal to Accounts Receivable and Accounts Payable Must have a creditor. This is to ensure the Control account balances the open invoices amounts. - The opening balance journal will not have a creditor or debtor and hence must have exactly the same value as found in the system
- The balance on your opening trial balance in these accounts should already be the balance in the system
- Upload of all open invoices (debtor and creditor) will set the balances to be the same in our system as the trial balance you are uploading - make sure the dates on these are prior to the opening balance journal date.
- Therefore no changes will be required to those GL accounts
|
Columns required in the spreadsheet
...