I am trying to upload a TB. My base currency is LKR. However I also have two cash accounts on USD and GBP. In the upload, I specify the correct currency amounts and load the TB. I am able to release it as well. However the GL batch that gets created does not balance. Its based currency is LKR, but the two entries for the denominated accounts, it shows the foreign currency values, not the relevant LKR (Base) value. Is this a bug or am I missing something here?
Answer
Trial Balance upload with denominated accounts
Best answer by Olga Anisimovich
Indeed, when the system shows the foreign currency values for a transaction generated by TB import, you may notice that the debit total does not equal to the credit total if you uploaded balances of the accounts denominated to a foreign currency. Switch to the base currency view by clicking the View Base button to see the batch totals in the base currency. If they are equal, then your batch is in balance and you can release it.
+1Indeed, when the system shows the foreign currency values for a transaction generated by TB import, you may notice that the debit total does not equal to the credit total if you uploaded balances of the accounts denominated to a foreign currency. Switch to the base currency view by clicking the View Base button to see the batch totals in the base currency. If they are equal, then your batch is in balance and you can release it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.