I performed three similar intergrations with Quickbooks and VBA.
Wrote an enitre ERP accounting module using SQL server and VB.NET 1 million lines of code.
Understand all aspects of account AR,AP Cash account reconciliation, Journals, Fiscal Periods, Chart of Accounts General Ledger.
Built many web api both SOAP and Rest
15+ years experience with MS Access all versions.
Use Xero for my own books.
Really would enjoy this project its my niche.
Warm Regards,
Nathan