Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odgovori
2498 Prikazi

I am trying to import excel journal entries using a template (from exporting Journal Entry) but can not map the fields correctly. My understanding is there should be 2 lines entry one for credit and the other for debit. One field that I can't map correctly is "Match #" I think this should be the number used to identify each Journal Entry. Is this correct?

I get various error depending on the fields mapping.

Such as:

Error at row 0: "An error has occurred. The move (Draft Entry A1 JE101) is not balanced. The total of debits equals $ 0.00 and the total of credits equals $ 20.00. You might want to specify a default account on journal "Miscellaneous Operations" to automatically balance each move."

Error at row 1: "An error has occurred. The move (Draft Entry A1 JE101) is not balanced. The total of debits equals $ 20.00 and the total of credits equals $ 0.00. You might want to specify a default account on journal "Miscellaneous Operations" to automatically balance each move."

Any help would be great.


Thanks 

Keith

Avatar
Opusti

Hi Dave,

Can you provide some images or a more complete google sheet?

Best Answer

Same the issue am facing. Anyone please help

Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
1
maj 24
1735
2
maj 25
1386
1
feb. 22
2409
0
jun. 23
2661
0
jul. 17
3751