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

المنشورات ذات الصلة	الردود	أدوات العرض
Accounting--> Balanch Sheet's Chart of Accounts Customization accounting	1 أغسطس 25	161
Reconciling Credit Cards - Merchant Settlements for multiple Customers matched to one statement line accounting	1 أغسطس 25	294
I can't see the Receipt button after enabling the Sales Receipt option in Accounting تم الحل accounting	2 أغسطس 25	450
Follow up actions on overdue invoices V17 -> 18 accounting	2 أغسطس 25	1240
Products with PRICE lists accounting	2 أغسطس 25	1149

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!