Tool to Calculate the Journal Entries Needed to Replicate the QuickBooks Checkbook Entries in the Aplos System.

The next big task is getting all the QuickBooks Checkbook entries entered into the Aplos system.

This is very similar to calculating the Cord Ministries Fees from the Aplos “Detailed Donations by Contact” Report except that this time the data source is the QuickBooks Checkbook output file.

  1. Download the “Checkbook” Report from QuickBooks.
  2. Upload this report into the “R” Language Shiny webpage.
  3. Process the report to build the Aplos journal entries.
  4. Download the Aplos journal entries file.
  5. Upload the journal entries into Aplos.

Here is the link to the “R” Language Shiny Webpage that runs the application. Feel free to give it a try – of course you will need data so send me a note if you are interested.

Leave a Reply

Your email address will not be published.