Skip to Content
Menú
This question has been flagged
1 Respondre
2384 Vistes

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
Descartar

Hi Dave,

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

Best Answer

Same the issue am facing. Anyone please help

Avatar
Descartar
Related Posts Respostes Vistes Activitat
1
de maig 24
1615
2
de maig 25
1293
1
de febr. 22
2333
0
de juny 23
2568
0
de jul. 17
3649