ACCURATE RECORD KEEPING

Accounting Projects

Not Finished

SAP Reporting Using MS Power BI

Not done

Double the Fun

Our non profit customer had a problem: they had a board of volunteers that changes every year and requires dual signatures on cheques. Getting the two volunteers together to sign semi monthly payroll cheques was an issue. We set them up on Telpay (a Canadian company out of Winnipeg) which allows the two authorized signers to email their authorization. It’s a great solution when two people need to sign cheques. We process the payroll and input the direct deposit values, then Telpay emails them for their approvals, we receive 2 approval codes and finalize the transaction and their employees receive a direct deposit. No more chasing signatures and no more delivering cheques. Now it’s on time every time without the headaches.

Save the trees

We were approached by an Edmonton company that was drowning in paper and knew they could improve, but didn’t know how. We implemented our paperless processes and the impact was immediate. No longer was the business buying boxes of paper and draining the ink on their printers. No longer was the office looking like a paper castle. Now the workload is visible in their systems and not lost on someone’s desk. Sorry Staples, we’re saving the trees.

QuickBooks Mashup

A St. Albert business owner approached us with bookkeeping headaches. She had a store front in St. Albert as well as in another town. It didn’t take long to discover that the books were being kept in two separate QuickBooks desktop data files — for one business. No wonder she had headaches! We took the data from both QB files and merged them into one master QB file. To accommodate for the different locations, we created classes. This allowed the business owner to see how each location was performing on the income statement. This project involved exporting years of historical data and creating a new QB file so that the business owner could now see the whole picture. No more Advil needed.

Open Dental Sync

We were asked to do the bookkeeping for a dental clinic that was using Open Dental for their front end customer/procedure management and QuickBooks Online. The challenge was to capture all the income and customer payments from Open Dental and carry that data over to QBO without manually duplicating it. With some SQL Queries we were able to customize the data that was exported from Open Dental. And thanks to an app called Transaction Pro, we were able to quickly and accurately do these imports. This allowed the business owner to have timely financial reports since we could record the revenues in QBO much quicker…giving us a WHOLE picture.

Shopify Sync or Sink

This was a really fun project to do. We were able to help the customer to export sales and inventory data from Shopify to their QuickBooks Desktop. Prior to us coming on board, the owner would manually enter each Shopify customer order into QB Desktop. You can see how time consuming this can be especially during peak sales. Since the sales info was already in one system, we opted to use Shoplink to extract the data from Shopify and import it into QB Desktop. Along the way, we did this again for another customer that was using QB Enterprise. This export required the use of Shoplink Integrator, a very cool tool. We learned a lot on both of these projects and are happy to say both customers were very pleased with the outcome.

Chamber of Commerce

We were asked to clean up the current Chamber Master data and then export the data on a monthly basis into QuickBooks Online. – NOT DONE