Hi,
I’m trying to import our historic data for 2025 into Frappe Books using the Journal Entry import wizard and cannot succesfully import anything.
I have tried with the following CSV formats in the template document (with the 3 header rows left untouched):
CSV Format 1:
[blank],[blank],Journal Entry,2025-08-28,300029713,2025-08-28,[info about payment],6240 - Professional Dues and Subscriptions,1010 - Operating Bank Account,155,155
–> Fails with “No entries were imported” (I assumed it could autogenerate the numbers since the documentation on this journal imports seems rather scant).
CSV Format 2:
Hist-2025-01,JV-,Journal Entry,2025-08-28,300029713,2025-08-28,[info about payment],6240 - Professional Dues and Subscriptions,1010 - Operating Bank Account,155,155
Fails with “total debit $155.00 must be equal to total credit 0.00” repeated for debit values for each row.
CSV Format 3:
Hist-2025-01,JV-,Journal Entry,2025-08-28,300029713,2025-08-28,[info about payment],6240 - Professional Dues and Subscriptions,155.00,0.00
Hist-2025-01,JV-,Journal Entry,2025-08-29,2025-08-29,[info about payment],1010 - Operating Bank Account,0.00,155.00
Unsurprisingly fails with a note that the account information is missing.
I’d appreciate suggestions as to how to fix this. Thanks.