Skip to main content

Streamtime and QuickBooks

Connect with QuickBooks for seamless integration, no double-entry and invoice reconciliation

Updated over 10 months ago

Heads up!

From June 2024, in order to integrate your Streamtime with an accounting platform, you will have to enable Two-Factor Authentication for security purposes. Find out how here.

You can link Streamtime to your QuickBooks account and copy your invoices across in one click, meaning that invoices don't need to be manually re-entered in QuickBooks. Read on or skip to the end for a video walkthrough.

πŸ‘©πŸ»β€πŸ’» Setup The Connection


To setup the connection between Streamtime and QuickBooks, just head to Integrations.

Find the QuickBooks tile and click Connect.

You'll then be redirected (via horseback πŸ‡) to QuickBooks to enter your log in details. You'll then be redirected again (this time via magic carpet ✨ ) back to your Streamtime.

βš™οΈ Setup


Once you've connected, you'll see a connection tile under the heading, Your accounting package connections. Click Edit Connection on the tile to assign branches, invoicing number sequence and account code defaults.

Invoice numbering system

Your connection will automatically take the invoice numbering sequence of your home branch. You cπŸ““an continue with this, or create a new sequence. You're also able to view and edit the next number in the sequence from here.

Assigning branches

Select the branches you want to associate with this connection. Once saved, any invoices, purchase orders and expenses will be sent to this connection.

Default Account Codes

When creating invoices and purchase orders from the selected branches, you can assign default account codes for revenue and expenses here. If you want to set up specific account codes for different line items, you can do so from your Master Settings.

πŸ“’ QuickBooks Account Codes


Streamtime allows you to select specific account codes from QuickBooks against each item, saving you having to manually do this once the invoice is copied over.

You can set up and manage these within QuickBooks and these will show in Streamtime once you have connected.

Tax rates are connected to these account codes within QuickBooks itself so will pull through on the invoice.

If you work regularly with the same items and expenses, you can assign a specific account code within Master Settings to avoid you having to manually enter these each time.

🧾 Invoicing


Once you know how Invoicing in Streamtime works, you can create your invoices.

If you have any items or expenses built using master settings, you can see how they pull through the set account codes straight into your invoice.

When you're happy with the invoice, simply click on Copy to QuickBooks and it will be sent, meaning that invoices don't need to be manually re-entered in QuickBooks.

Your invoice will be marked with a green QuickBooks stamp, which will take you directly to the invoice in QuickBooks when clicked.

If you send the invoice to your client or manually mark the invoice as sent directly from ST, before copying the invoice to QuickBooks, the invoice will show as approved in QuickBooks. Otherwise, you can manually approve the invoice in QuickBooks itself.

You can record a payment in ST and the integration will update QuickBooks.

πŸ“Š Reporting


Within a Job, you can expand the invoices turnkey to see a summary of the invoices.

From the jobs list, you can click on the Invoice tab and set columns/filters to access key information across all Jobs. Custom reports allow you to save your favourite list views and switch between them at the click of a button.

P.S. You can watch us talk through the QuickBooks integration in the video below.

VOILA! Couldn't be easier.... But if you have any further questions, just let us know using the Help button in your side-menu, or by sending an email to help@streamtime.net

.Β 

Did this answer your question?