How to format a General Ledger import from QBO?

Question

I've watched the tutorial course on importing the exported data from Quickbooks. I exported the Excel file from QBO, as well. In the example of importing the General Ledger spreadsheet in the tutorial at 3 min., the trainer's sheet shows the first column as "Account" with codes underneath it. My exported QBO Excel sheet of the General Ledger shows the name of each account in the first column with a chronological listing of the transaction info in that account in the next few columns. Is the trainer not importing an exported General Ledger sheet?

https://www.odoo.com/slides/slide/7312/share

Elina · Answer

It will not be the exact file you would import. You have to edit data on QB extract of GL to avoid duplications that may come from outstanding records. The edits are shown on the right side table. Finally, you will transform the table into a journal entry and upload in Odoo.  image [1]

[1] /web/image/80930585-6a3576f3/image.png?access_token=21f7b523-cc6f-480e-9eb2-791284a3d1e4

İlgili Gönderiler	Cevaplar	Görünümler
Listing all Invoices with their line items and custom Product fields accounting	0 Ağu 25	384
simplified chart of accounts for non-profit organization accounting	1 Ağu 25	428
Why does the same bank transaction appear on different bank statements? How can I fix it? accounting	0 Ağu 25	358
Bill import template accounting	2 Ağu 25	339
Analytical distributions by amount in accounting app Çözüldü accounting	2 Ağu 25	865

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!