Tag: Upload Journal Entries

Tool to Calculate the Aplos Journal Entries to Replicate the QuickBooks Credit Card Fees

The next step in the process is to add the credit card fees that need to be charged to each donation. These charges are accessible in the QuickBooks Journal Report.

The QuickBooks Journal Report is an MS Excel spreadsheet that is nice for human consumption. But, there does not seem to be any QuickBooks provision for getting a nice clean machine-readable format so we work with what we have.

So, the real work of this “module” is building a QuickBooks Journal Report decoder. The rest of this application has already been built and is simply being reused. In fact, the human interface is starting to become a bit standard…

The workflow is pretty much the same as well…

  1. Download the QuickBooks Journal Report  Report from QuickBooks Online (a horrible experience for all concerned!)
  2. Upload this report into the “R” Language Shiny webpage.
  3. Check the QuickBooks Journal Report for errors and process it to build the Aplos Journal file.
  4. Download the Aplos Journal file.
  5. Upload the Aplos Journal file 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.

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.

Calculate Cord Ministries Fees from the Aplos “Detailed Donations by Contact” Report

I’m excited!

This is my first “R” Language task for the new Aplos Fund Accounting system.

The task is relatively simple:

  1. Download the “Detailed Donations by Contact” Report from Aplos.
  2. Upload this report into the “R” Language Shiny webpage.
  3. Process the report to build the Aplos journal entries to Transfer Donations to Funds and/or to Transfer Fees to General Fund.
  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 – you will need data so contact me if you are really serious.