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.

Sunshine and Spreadsheets: A Bookkeeper’s Summer

Summer means different things to different people.
For some, it’s beach vacations, backyard BBQs, and long weekends.

Mileage Matters. Don’t Let Those Miles Go to Waste! Let Them Reduce Your Tax Bill!

Do you own your own business? If so, make sure you are not missing this one simple deduction! If you use your car for work, your mileage could be saving you money on taxes.

What to Bring to Your First CPA Appointment as a Small Business Owner

Walking into your first CPA appointment as a small business owner can feel a little intimidating. You might wonder if you’re bringing the right paperwork, if your records are organized enough, or if your CPA is about to discover the “creative bookkeeping system” you’ve been using since opening day.

Never Miss a Quarterly Estimated Tax Payment Again: TaxDome Keeps You on Track

For self-employed individuals, freelancers, business owners, and investors, quarterly estimated tax payments are an important part of staying compliant with IRS requirements. Missing a payment can result in penalties, interest charges, and unnecessary stress. Fortunately, TaxDome makes it easier than ever to stay organized with automated reminders and client communication tools.

Summer Reminder: Don’t Forget Your Estimated Taxes!

We know—writing a check to the IRS and State is probably not on your summer bucket list.

IRS Updates to 1099-K Reporting: What Freelancers Should Expect in 2026

If you’re a freelancer, gig worker, or small business owner who gets paid through platforms like PayPal, Venmo, Etsy, or Uber, there are important tax changes you need to be aware of.

Taxes and Summer? Who Would Have Thought?

When you think “summer,” taxes probably don’t make the list – and honestly, we get it. You should be thinking about vacations, BBQs, and soaking up the sunshine.

Why You Should Get an IRS IP Pin

Protect Yourself from Tax Identity Theft

At Senter CPA, we’re serious about protecting your personal and financial information. One simple but powerful way you can protect your tax identity is by getting an IRS Identity Protection PIN (IP PIN).

Here’s what it is, why it matters, and how to get one.

Confessions of a Bookkeeper

Let’s clear something up right away: bookkeeping is not just typing numbers into a spreadsheet while drinking coffee and judging people’s expense decisions.

Well, it’s partly that. But there’s so much more to it.

Received an Odd Michigan Treasury Notice? You’re Not Alone

If you recently received a strange notice from the Michigan Department of Treasury, take a breath. You are not the only one.