Syncing QBO Advance with Excel

by | Jun 11, 2024 | Accounting, Tax

QBO Update:

Great news for Quickbooks Online Advanced customers. Intuit has created a new Spreadsheet Syncing option for QBO Advanced users with Office 365!

This will allow customers to securely move data from Excel (Office 365 version) to QBO Advanced and vice versa.   The main benefit of this option is to open up more possibilities for customizing reports to fit the needs of each unique customer’s reporting methods.  Whether adding a graph or a specific table style to a report would benefit your financials, more possibilities are now available for Quickbooks Online Advanced customers.

To initiate, an Admin will have to:

  • Go to Settings then choose Spreadsheet Sync.

Or

  • Go to Reports and click the Spreadsheet Sync tab.

Then follow the setup steps to guide through the setup.  This will need to be done the first time for each customer, but after the initial setup is done, reports can easily be created and synced to QBO Advanced moving forward.

Please call our office if you have any questions.

248.934.0550

Always remember, Senter, CPA is here for you if you need any assistance.

Don't hesitate to give us a call at 248-934-0550, or contact us below.

Your Year-End Tax Bill Shouldn’t Be a Surprise

December has a way of making tax planning feel urgent—but by December, you’re already behind the strategy and some of the best planning opportunities could have already passed you.

Fall Accounting

It’s like spring cleaning, but now we’re working on it in between Back to School and Football and Pumpkins and Mostly Great Weather!

Trump Accounts: What Parents—Especially Michigan Families—Need to Know

Trump Accounts are a new type of savings vehicle designed to help families build long-term financial resources for children. Structured as a special type of traditional IRA, these accounts have specific rules governing eligibility, contributions, investments, and withdrawals.

Senter Forward: The Kind of Client Relationship We Want to Build

I will start with something that may sound strange coming from a CPA firm: we are not trying to take every piece of work that walks through the door.
We have reached a point where the question is less “Can we prepare this return?” and more “Can we build a relationship here where our team can actually help?” That difference matters.

Federal Updates on Tip And Overtime Tax Deductions

Recent federal tax legislation introduced new deductions related to qualified tip income and overtime pay. These changes may benefit eligible employees while also creating additional reporting responsibilities for employers. At Senter CPA, we are helping both businesses and individual taxpayers understand how these rules apply and how to stay compliant.

1099 Filing Requirements Update! Yes, this is good news!

The reporting amount threshold has increased. Yes, you read that right! The old $600 filing requirement for 1099-MISC & 1099-NECs has been increased to $2,000, with some minor exceptions.

To jog your memory, if you need it, you are required to file 1099s to those who you pay for rent, contract labor (not through your payroll), interest, etc. The 1099-MISC is most commonly used to report rent, while the 1099-NEC is mostly used to report non-employee compensation to most everyone.

Mid-Year Financial Checkup Checklist: Are You on Track for 2026?

Summer is a good time to check in on your finances. The year is already halfway over, which makes it easier to see what’s working and what might need attention. Maybe your income has changed. Maybe you’ve spent more than expected or fallen behind on a savings goal.

Understanding Quarterly Estimated Tax Payments

If you’re self-employed, a freelancer, or a small business owner, quarterly estimated tax payments are an important part of staying current with your federal tax obligations. Because taxes typically aren’t withheld from self-employment income, the IRS requires many taxpayers to pay taxes throughout the year instead of waiting until they file their annual return. Making timely estimated payments can help avoid a large tax bill and potential underpayment penalties.

Why I Visit Our Accounting Clients

Every couple of years, I spend part of my summer leaving the office.

That probably sounds strange coming from a CPA.

Have You Moved Recently? Make Sure the IRS Has Your New Address

Moving into a new home is an exciting milestone, but one important task is often overlooked: updating your address with the IRS.