We are looking for an experienced SQL reporting developer for an initial 1-2 month project with ongoing requests as needed.
1. Create custom SQL Query to pull Quickbooks Data from the following locations in QBs with specific date selection available for all data:
a. Balance Sheet
b. General Ledger (GL) Balances
c. A/R Aging Summary Report
d. Profit and Loss Statement
Example: SQL Query to extract receivables amount on 1st day of the month from the GL Account “1200 – Accounts Receivable”. Also be able to extract “Ending Total Receivables” amount from the “A/R Aging Summary Report” as of the last day of the month. Import both queries into the Business intelligence software program (BrightGauge) we use for reporting, and be able to use both #’s to create a calculation for the final value to display as a gauge.
2. SQL Query will be input into the BrightGauge (BG) software program, which already has an established and working Datasource connection to our QB’s file, to build a Dataset. The Dataset’s should display field’s for the different data (such as balance, account type, date, etc) from the items listed in 1a – 1d.