How to Update the Deposit to Account in Mass with Spreadsheet Sync

by

Hello, everyone! As we all travel back to our desks after eating all the turkey, we still have year-end to do and sometimes that comes with some clean up tasks.  

In this video, I'm excited to guide you through the process of using Spreadsheet Sync in QuickBooks Online (QBO) to efficiently make mass edits, a technique particularly useful for year-end financial cleanups.

Scenario: Year-End Invoice Management 

Imagine it's the year-end, and you have invoices from a previous period that need attention. Your goal is to create credit memos to manage these invoices effectively, controlling aspects like the dollar amount and the date of issue. This process is crucial for applying these memos to the respective open invoices.

Step-by-Step Process Using Spreadsheet Sync

  1.  Starting with Open Invoices: First, I'll show you our open invoice report in QuickBooks, highlighting the invoices from the previous year that need to be written off.
  1. Initiating Spreadsheet Sync: Next, I head over to Spreadsheet Sync. Here, I select 'add and edit data' using our invoice template. I then integrate our demo company's data, pulling in all existing invoices for the period in question, specifically focusing on the last year. 

Creating the Credit Memo Table: Our next step involves creating a credit memo table. This table is vital for generating the credit memos. We start by transferring the data from those three open invoices we initially identified. 

Editing and Syncing: In the credit memo table, I begin editing the names, ensuring they are marked as credit memos and retaining the original invoice numbers for easy tracking. I set the dates for these memos, aligning them with our needs for write-offs. 

Finalizing and Updating QuickBooks: The crucial step is selecting a new transaction type to post in QuickBooks, marking it as 'yes' to initiate the sync. This action confirms our intention to update QuickBooks with this new information.

Verification and Completion: Finally, we return to QuickBooks, refreshing our report to observe the impact of the credit memos. The ideal outcome is seeing the dollar amount balance out to zero, indicating a successful update.

This method is an incredibly efficient way to generate credit memos and apply them to close invoices quickly, all through the power of Spreadsheet Sync. 

I hope this tutorial was helpful, and I look forward to sharing more insights with you all soon!