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

Related Posts	Replies	Views
Listing all Invoices with their line items and custom Product fields accounting	0 Aug 25	384
simplified chart of accounts for non-profit organization accounting	1 Aug 25	428
Why does the same bank transaction appear on different bank statements? How can I fix it? accounting	0 Aug 25	358
Bill import template accounting	2 Aug 25	339
Analytical distributions by amount in accounting app Solved accounting	2 Aug 25	865

This question has been flagged

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