Typically in uploading accounting opening balance to get history you would do monthly transaction summaries. Is there a step by step guide to this so when trial balance is run is balances the system its coming from. The issue we face is Ofbiz is a real time accounting system so any uploads affects running totals ________________________________ From: Omar Abdullwahhab <[email protected]> Sent: Tuesday, July 29, 2025 2:33 AM To: james productive1.com <[email protected]> Cc: ofbizuser <[email protected]> Subject: Re: Starting Ofbiz Accounting - Opening Balances
Good morning James, In case this is the first time for you with ofbiz. please read this accounting tutorial ( by Sharan Foga ) https://cwiki.apache.org/confluence/download/attachments/67635031/Getting%20Started%20with%20Apache%20OFBiz%20Accounting%20Detailed%20Tutorial.pdf?api=v2 And regarding transferring accounts and inventory and opening balances -- there is an option in the webtools module from which you can upload your data as xml. The best way to upload data is to correctly understand the data model of ofbiz and map it to the data model of quickbooks. Thanks Omar. On Tue, Jul 29, 2025 at 4:24 AM james productive1.com<http://productive1.com> <[email protected]<mailto:[email protected]>> wrote: Good Afternoon. Is there any documentation on the steps to launch Ofbiz with financial history for a distribution company. The scenario is the ofbiz user is on Quickbooks and wants to go live August 1st 2025. They would like to bring over financial history for the calendar year 2025. What is the process to upload this data were the financial data in Quickbook and Ofbiz reflects the same numbes. Things to Consider Customer has inventory Customer has Open AR/AP Customer has Open Sales Orders and PO Customer has Sales Revenue Account What is the best way to upload data to start Ofbiz with the correct financials? Thanks, James -- Omar Abu-Arab Java Engineer
