To connect your STRATAFOLIO account to your QuickBooks Online account (sometimes referred to as QuickBooks Software Online), follow our easy integration instructions. This connection is the foundation for seamless financial management across your portfolio, helping you cut down on manual data entry and keep everything aligned between systems.
Get Started by Logging In
To begin, log into your STRATAFOLIO account and head to the left-hand navigation panel.
Navigate to Organizations, and then select Integrations. From the Integrations tab, select Add An Integration.
Choose QuickBooks Online
You will then see the integration options page. Select QuickBooks Online, and then choose Add Integration.
From the dropdown list, select the correct Entity in STRATAFOLIO that you want to integrate with QuickBooks Online. Please use caution during this step, as some accounts may have very similar names. Verifying you’ve selected the right entity will prevent unnecessary rework later. Once confirmed, choose Proceed to Setup.
Authorize the Connection
Next, you will start the integration process. When prompted, you will be redirected to the QuickBooks Online login page. This is where you authorize the connection between STRATAFOLIO and your QuickBooks account.
Follow the login prompts carefully, ensuring you connect to the correct QuickBooks Online account associated with the entity you selected in STRATAFOLIO. QuickBooks will ask you a few security authorization questions. Complete these prompts, and STRATAFOLIO will then finalize the integration.
Refresh and Review
Once you complete the setup, refresh your page in STRATAFOLIO. You should see the Accounts tab with a green number beside it, showing that your connection is active. Depending on the size of your data, it may take several minutes for the system to import and sync everything. For organizations with many entities or years of financial history, expect the process to take a little longer the first time.
Why the Integration Matters
Connecting STRATAFOLIO with QuickBooks Online gives you a single source of truth for both operational and financial data. Instead of logging in and out of different QuickBooks accounts or manually updating spreadsheets, you can access the information you need directly in STRATAFOLIO.
The integration allows you to:
- Quickly view balances across all entities.
- Eliminate duplicate data entry.
- Ensure consistency between your books and your property operations.
- Simplify reconciliations at month-end.
- Save time by reducing the back-and-forth between systems.
By syncing your financial data into STRATAFOLIO, you give your team real-time visibility into the financial health of your portfolio.
Common Scenarios
Here are some common situations where the QuickBooks Online integration proves especially useful:
- Managing multiple entities: You can connect each entity in STRATAFOLIO to its corresponding QuickBooks Online account without switching between systems.
- Auditing charges: Quickly confirm that all rent and NNN charges are being invoiced properly by cross-checking your books.
- Monitoring payments: See who has paid, who is past due, and where late fees may apply.
- Improving reporting: Build reports in STRATAFOLIO that automatically pull accurate financial data from QuickBooks.
Troubleshooting Tips
If you encounter any issues during the setup process, here are a few things to check before reaching out for help:
- Make sure you have admin-level access in both STRATAFOLIO and QuickBooks Online.
- Verify that you are logging into the correct QuickBooks Online account if you manage multiple accounts.
- Confirm that your QuickBooks Online subscription is active.
- Try refreshing your browser or clearing the cache if you don’t see the Accounts tab update right away.
If problems persist, STRATAFOLIO support is always available to help you with integration questions. For specific QuickBooks functionality, we recommend working with your accounting team.
Next Steps
Once you’ve completed the connection, you’re ready to take advantage of other powerful features in STRATAFOLIO. For example, you can set up user permissions so your team has the right level of access to financial data. To learn how, check out our Knowledge Base article on giving access to a user in STRATAFOLIO.
Creating Income Items in QuickBooks Online
Income Items in QuickBooks allow you to separate the type of income you receive without creating multiple income accounts. When creating an Item, you also specify the Income Account it is connected to. Essentially, you are creating sub-items under an Income Account. The Income Items are needed for invoicing and will be easily tracked in QuickBooks reporting.
At STRATAFOLIO, we highly recommend invoicing to track your tenants and their rental income. Using Income Items for each of your revenue types is a best practice for invoicing with QuickBooks Online. Also, Income Items are needed to utilize the invoicing functions in STRATAFOLIO best.
To better understand Income Items, it is helpful to see how they are set up and used for invoicing. In this article, we will show you step-by-step how to add Income Items to QuickBooks Online and how they are used in invoicing.
Typical Income Items
For Commercial Real Estate, the names can be whatever you feel best describes it. These are the typical Income Items that we recommend are:
- Base Rent
- CAM (Common Area Maintenance) Income/Expense Recovery
- Insurance Income/Expense Recovery
- Real Estate Taxes Income/Recovery
Adding Income Items in QuickBooks Online
- To add an income item, select the gear icon in the top right corner, then select Products & Services under Lists.
- Next, click the green New button
- Select Service from the list.
Most of the income items you use will be under service for commercial real estate since renting a building and common area maintenance are services you provide to your tenants. - Enter a Name for the Income Item, select the Income Account it will post to, then Save & Close.
Do NOT add a Class for your Income Item. You will add the Class when you create an invoice. This allows you to have fewer items created and causes less confusion.
- Repeat this process for each Income item that needs to be added.
NOTE: As you see in the image above, you can add additional information when you create the Income Item such as an SKU & Sales price/rate. Leaving those fields blank is preferred due to Rent & CAM rates varying from tenant to tenant and over time.
Using Income Items for Invoicing
Once Income Items are set up, they can be used to create the invoice for your tenants.
Notice that the Class is specified in the invoice. Selecting Class in the invoice rather than setting it as part of the Income Item allows a single Income Item to be used for multiple Classes.
Also, in the example above, four different Income Items are used. The last three, CAM, Insurance, and Property Taxes are all posting to the same Income Account even though they are three separate items on the invoice. Having items separated but still linked to the same Income Account is especially helpful when running reports on these operating expenses in QuickBooks.
| Income Item | Income Account |
|---|---|
| Rent | 40000 Rental Income |
| CAM Income/Expense Recovery | 41000 CAM & Recovery Income |
| Insurance Income/Recovery | 41000 CAM & Recovery Income |
| Real Estate Taxes Income/Recovery | 41000 CAM & Recovery Income |
How to Turn Off Custom Transaction Numbers in QuickBooks Online?
STRATAFOLIO has the capability of pushing invoices into QuickBooks Online. When this happens, QuickBooks Online assigns the invoice with a number and returns it to STRATAFOLIO. When the setting Custom Transaction Numbers is on, QuickBooks Online assumes the user wants to utilize their own custom invoice numbers and will not assign an invoice number. Every time an invoice is created, the user will go into QuickBooks Online and update it with a customer invoice number.
To utilize STRATAFOLIO to its full capabilities, including ACH, and save you a lot of time, invoice numeration needs to be used. This will allow QuickBooks Online to create the invoice numbers automatically for you and allow you to differentiate between invoices. This will need to be done in each QuickBooks Online account integrated with STRATAFOLIO.
How to begin
Gear Box on the top right of your screen and then Account and Settings.
Sales and then Custom Transaction Numbers to turn Off.
If you have created invoices prior to turning off this toggle, you will need to go back in and update their numbers manually in your QuickBooks Online accounts. The invoices in your portfolio in STRATAFOLIO will be updated with your invoice numbers that you have added in QuickBooks Online.
Reconnect QuickBooks When the Sync Breaks
One or more of your QuickBooks Online accounts has stopped syncing with STRATAFOLIO, and you have an error message. This can happen for a variety of reasons, such as your QuickBooks Online administrators have changed, passwords have changed, Intuit has changed the integration certificates, or any other number of reasons. This does not happen often, but when it does, a simple reconnection of the account(s) is needed. In other words, you’ll need to reconnect QuickBooks sync with STRATAFOLIO to get everything running again.
Where to Find Integrations in STRATAFOLIO
STRATAFOLIO connects to QuickBooks to keep your financial data synced and up to date. All QuickBooks integration settings are managed at the Organization level so they apply consistently across your hierarchy.
To find the QuickBooks integration settings, follow these steps:
- From the left side navigation menu, select Hierarchy.
- In the Hierarchy dropdown, choose Organizations.
- Select the Organization you want to manage.
- Open the Integrations tab.
The Integrations tab is where you can view, manage, and monitor your QuickBooks connection. This is the central location for syncing financial data between QuickBooks and STRATAFOLIO, ensuring your accounting and reporting stay aligned across your entire portfolio.
How to Know If You Need to Reset the Integration
On the Integration tab in the main Organization view in STRATAFOLIO, you will see a red bell to alert you that something needs to be looked at. After selecting the tab, you will see if there is an issue with account mapping or the integration syncing. If you see a red alert for syncing issues, this indicates that you need to fix a QuickBooks sync break by resetting the integration. You can find the information on How To Map A New QuickBooks Account in STRATAFOLIO Knowledge Base article.
For syncing issues, you will see the red Failure in the Status column and more information in the Error Message column.
If there is a yellow button saying Outdated, there is no need to do anything. This will happen if there has been no movement in your QuickBooks Online account for more than 72 hours. If you believe that you are receiving this message by mistake, please complete a transaction in QuickBooks Online to verify the integration. It should refresh in a few minutes. If it has been longer than an hour, please use the Contact Us button on the left-hand navigation bar for assistance.
How to Resync an Integration
These steps provide a QuickBooks sync broken fix that will reconnect your data and ensure STRATAFOLIO continues to pull in the most up-to-date information. Select the appropriate integration by clicking on the “i” for more information.
Inside the integration, select the Setup tab. This should show you the QuickBooks Online syncing error message if there is one. The most common errors are “Authorization has expired,” “Authorization denied,” “Unauthorized,” and “Authorization failed.”
Inside the Setup tab, there will be a green button Connect to QuickBooks. Selecting this will open up your QuickBooks account in your browser.
Select the proper QuickBooks Online account to reconnect. It is crucial to connect the same account previously linked to ensure correct mapping in STRATAFOLIO.
If any accounts have been added since the last successful sync, you may need to confirm any new additions, such as general ledger accounts or classes. See our Knowledge Base articles for more information on how to map Accounts, Classes, and Loans in STRATAFOLIO.
Repeat this process for any integrations with red Failure as the status in the Integrations tab.
Note: If you have a QuickBooks Desktop account, you will need to follow the directions for Updating Web Connector for QuickBooks Desktop as these instructions are very different.
