Quickbooks General Ledger

ProfitSystem® allows for its Revenue Report data to be exported to a General Ledger. Each time a new Revenue Report is printed, a transaction set is created for exporting. You can re-run the Revenue Report as many times as you like, and ProfitSystem® will replace the transactions IF they have not yet been exported. Also, ProfitSystem® will only create export transactions if you run the Revenue Report for one day, NOT if you run it for multiple days. ​ The transactions are placed in an ASCII export file. For QuickBooks 2001 or earlier the file name will be GENERAL.CSV and will be created in the directory specified in your Accounting Setup. For Quickbook 2005 and newer the export inserts the postings directly into the Quickbooks program with no intermediate file created. ​ The export file accumulates all of the daily transactions until the user PURGEs (deletes) them. Purging can be done as often as a user wishes, but at least once a year. To purge, use the Purge Menu from within System Maintenance. ​ The Revenue Report in ProfitSystem® has been designed to balance, like a GL debit/credit entry would have to. In some circumstances the report may not balance. To handle these situations ProfitSystem® will force the GL Export to balance by calculating the amount to make it balance and placing it in with the day's transactions with the Over/Under GL account number specified in the GL Account Setup. The user will have to manually reconcile the discrepancy and place it into the correct GL distribution. ​ General Ledger Exporting Procedures Before exporting the day's GL information, you must first run a Revenue Report for the day (you would normally be doing this at the end of every business day anyway). ​ To export the GL data, go to Export Accounting Transactions form, located at Main->Housekeeping->Accounting Integration->Export AP/GL. This form will first display the total number of general ledger transactions it will be exporting. If satisfied check the checkbox next to the gl transactions total to proceed.