Last post Jul 03, 2017 12:34 PM by Rivelyn
Jul 01, 2017 01:52 PM|Rivelyn|LINK
Our in-house MVC application is currently presenting the accounting department with a simple General Ledger Batch Summary by date range report like so:
Account Number / Name Class Debit Credit
10340 - CASH H40 $$$ $$$
11140 - POS H40 $$$ $$$
And so on.... Accounting depart is currently performing manual journal entries into QuickBooks for each account and have requested an automated solution.
I am looking for some input from the community to see if anyone has created something similar and what approach/solution you used. There are several options out there and I am not sure what is my best option. There are free solution provided from QuickBooks
like .iif files, but there is no shortage of comments about how .iif imports can corrupt the QuickBooks database. Also the SDK provided from QuickBooks that I take you would use along side the Web Connector. There are also several 3rd party purchasable software
packages out there like synergration's OpenSync and CoreObjX.
Any help would be greatly appreciated.
Jul 03, 2017 06:17 AM|Zhi Lv - MSFT|LINK
MVC Web App Data Output to QuickBooks Desktop, Anyone Have Recommendation?
From your description, it seems that you want to display the Web App Output Data on the QuickBooks Desktop. From my point of view, I suggest you could export the Web App output data to the Excel file, then import it into the QuickBooks.
More details about export data to excel file, you could refer to the following links:
Jul 03, 2017 12:34 PM|Rivelyn|LINK
That's actually a great start! I knew that was an option, and I know at some point accounting would like to be more or less completely hands free. But for now this would let them see the numbers that where being imported, and at the same time would save
them having to enter each number manually.