NewPath-Consulting / quickbooks-for-wildapricot

QuickBooks for Wild Apricot - Never miss an entry and have peace of mind knowing your books are always up-to-date with accurate transactions. Reduce stress and errors with automated, categorized entries from Wild Apricot to your QuickBooks accounts.
https://newpathconsulting.com/waqm
Apache License 2.0
1 stars 1 forks source link

New transaction type of "Sales Receipt" (Payments without Invoices) #78

Open thelontx opened 2 years ago

thelontx commented 2 years ago

Some customers do not want Invoice details inside Quickbooks. They just want to track Payments and Income by program. A simple Payment transaction inside Quickbooks does not allow Income tracking. An accountant may manually designate Income associated with a Payment (using journal entries) to the proper Income account, but this is a very manual process and may require research if the Payment does not have enough info.

QBWA has the capability to read Invoice data from WA to derive proper Income mappings (accounts). This Invoice reference and account mapping may be used in conjunction with the Payment transaction data to create a "Sales Receipt" transaction inside Quickbooks. The transaction will have the proper accounts AND can include the reference information (in notes/comments) to identify the WA Invoice or program details for traceability. The Sales Receipt transaction is still created against the "Customer" as identified in Wild Apricot.

High level scope of changes: Already solved: the challenge of creating Sales Receipt documents inside Quickbooks. This is what is used for Donations from Wild Apricot.

  1. updating the QBWA Config to support the new transaction type (new section; clear delineation on using this OR Invoices)
  2. corresponding changes to the Mapping Guide for inputing client data [changes to Marketing info also needed?]
  3. new Core scenario for the Transaction Type (using Invoice/Payment data from WA to map properly). Clone existing scenario and modify.
  4. new branch inside the QBO Txn scenario for the Sales receipt (model on existing Donation transaction)
  5. new branch inside the QBD Txn scenario for the Sales receipt (model on existing Donation transaction)