Posts Tagged ‘Pull Balances’

VSS: How to Push Invoices and Pull Balances with QuickBooks

April 22nd, 2016


If your VSS system is configured with QuickBooks using our FM Books Connector, you can push invoices to and pull balances from QuickBooks. Please contact PCI if you wish to configure VSS with QuickBooks.

Pushing an Invoice to QuickBooks:

Once you have a completed order, you can push it to QuickBooks by locating the QB menu item in the top toolbar.
This QB drop down will give you three options:
1. View in QuickBooks
2. Push/ Update Invoice to QB
3. Pull Invoice Balance
When you click Push/Update Invoice to QB, you will see a series of popups as the invoice pushes. The first will ask if you wish to continue, the next will indicate the invoice is pushing, and the third will indicate if the invoice pushed correctly.


After you have pushed an invoice, you will notice that the Overall Status will state “Pushed to QB” and the Pushed to QB status will indicate the date of the push.


If you make edits to the order after it has been pushed to QuickBooks, you can select Push/Update Invoice to QB and it will update the invoice in QuickBooks.
Pull Invoice Balances:
You can post payments in QuickBooks and easily pull over balance information in VSS.

When you click “Pull Invoice Balance”, it will ask you if you wish to pull balance information for a Found Set or This Order.


Found Set:

Clicking Found Set will pull balance information for all of the orders in your found set (if you have performed a find) or it will update the balance information for all records in your system if you have not performed a find.

For Example: In the graphic below, I performed a find for all invoices for a specific time period. My found set was 10 records. If I clicked Found Set on the pull balance prompt, it would pull the balance information for these 10 orders.

In this graphic, I did not perform a find, so I am currently managing all orders in my system (84). If I clicked Found Set, it would update the balance information for every order that had been pushed to QuickBooks. Please note, if you have a large number of records, this could take some time.


This Order:

Selecting this option will only pull the balance information for the current record you are viewing.

Once you have pulled balance information, your Paid On status will update with the date of the last payment.
The More Info tab provides you additional information such as the QuickBooks ID, when the invoice was pushed, the last time the balanced was checked, and the invoice’s current balance.

View in QuickBooks
In order to “View in QuickBooks” you need to first push the order to QuickBooks.
Clicking this option will open up the invoice in your QuickBooks file for easy reference and editing.