PLEASE NOTE:
The majority of the contents in this guide apply to both StudioPlus Spectra AND myStratus Desktop.
In most cases, instructions referring to "Spectra" also apply to myStratus Desktop.

Search:
Contents
:
BookmarkPrint

Home > Accounting > FAQ - Reconciling with QuickBooks
FAQ - Reconciling with QuickBooks

    
NOTE: This feature is available in the Professional and Enterprise versions of both Spectra and myStratus Desktop.

Q: How can I reconcile Spectra/myStratus with QuickBooks (or other accounting software)?

A: When using an accounting integration with QuickBooks (or other accounting software), you should regularly reconcile your Spectra/myStratus records with QuickBooks to verify the information matches. Depending on whether you use the accrual accounting method or cash accounting method, the steps for reconciling will vary. If you are unsure of which method your studio uses, you can check by going to Maintenance > Preferences > Company (Studio) Preferences > Accounting tab. See also: Company (Studio) Preferences - Accounting

Instructions:

Accrual Method

Note: Before reconciling, it is important that all invoices and payments have been posted. Any invoices and payments that have not been posted will be reflected in the Spectra/myStratus reports.
  1. Within Spectra/myStratus Desktop, print the "Accounts Receivable Aging Report" by going to Reports > Accounts Receivable Aging Report. See also: Accounts Receivable Aging Report  

  2. You will also want to print the "Customer Deposit Reconciliation Report" under Reports > Customer Deposits Reconciliation Report.  See also: Customer Deposit Reconciliation Report

  3. Subtract the total balance outstanding from your "Customer Deposit Reconciliation Report" from the total balance on your "Accounts Receivable Aging Report." 

  4. This total should match your accounts receivable general ledger account within QuickBooks. (This is the account listed under Maintenance > Preferences > Company (Studio) Preferences > Accounting > Accounts Receivable.)

See also: Setting up the Accounting Link

Cash Method

  1. Within Spectra/myStratus, print the "Customer Deposit Reconciliation Report" under Reports > Customer Deposits Reconciliation Report

  2. This total should match the customer deposits general ledger account within QuickBooks.

See also: Setting up the Accounting Link

What if the totals don't match?

There are many reasons the totals between Spectra/myStratus and QuickBooks could differ. Below are a few common issues and tips for resolving any differences.
  • Invoices or payments have not been posted - Be sure to post any payments or any invoices available to post before printing the reports.

  • Adjusting posted invoices or payments - If someone unlocks a posted invoice or payment and modifies or deletes the record, they must also make the change within QuickBooks. If they do not, this will cause a difference in totals. To prevent this, we suggest using security settings within Spectra/myStratus where you limit who can unlock a posted invoice or payment. See also: Setting up Security

  • Re-exporting invoices or payments - Before re-exporting a posting report, you must delete the original posting from within QuickBooks.  If this is not done, the information will now be doubled.

  • Posting without having QuickBooks open (QuickBooks direct only) - When posting to QuickBooks, you must have QuickBooks open on the computer where you are completing the posting. If you do not have QuickBooks open and logged in, the posting from Spectra/Stratus will not be completed. It may appear as posted within Spectra/myStratus but does not appear within QuickBooks. To correct this, re-export by going to Tools > Accounting Link > Re-Export Posting Reports.

  • "IIF" file has not been imported - For those not using the direct link with QuickBooks, an "IIF" file is created that can be imported into QuickBooks later. If this file has not been imported since the last posting within Spectra/myStratus, it will not be reflected within QuickBooks. Be sure that the "IIF" file has been imported before reconciling.

  • "IIF" file posted multiple times (for QuickBooks only) - Once an "IIF" file has been imported into QuickBooks, the file should be deleted, moved, or renamed so the transactions are not imported again.

  • Accounts Receivable General Ledger Account within QuickBooks - Verify that the Accounts Receivable General Ledger account within QuickBooks is only being affected by Spectra/myStratus exports. When viewing this account within QuickBooks, you should only see Spectra/myStratus Export posts increasing and decreasing this GL account. 



See also


Was this information helpful?YesNo

How would you rate this page?