Reporting & Reconciling Made Simple: Three QuickBooks Quick Tips

Hey there, QuickBooks users! Ever find yourself needing a quick and easy way to handle some common Reporting or Reconciliation tasks in QuickBooks Online? You've come to the right place! We've got three simple "Quick Tips" to help you out.

Tip #1: How to Download Your Profit and Loss Report

Need to get your Profit and Loss report into a file you can share or save? It’s super easy! 

1. Head to the Reports Menu: Look for "Reports" on the left-hand side of your QuickBooks dashboard.
2. Find Your Report: Go to "Standard reports" and type "Profit and Loss" into the search bar.
3. Customize It: Now, you can adjust the date range to whatever you need—like "Last Month" or "This Year to Date." The report will automatically update.
4. Download and Go! In the top-right corner of the report, you'll see a little export icon (it looks like a box with an arrow pointing out of it). Click it and choose "Export to Excel" or "Export to PDF." Your file will download automatically!

And just like that, you've got your Profit and Loss report saved and ready to go!

Tip #2: Undoing Past Bank Reconciliations

Mistakes happen! If you need to undo a past bank reconciliation, here’s how to do it.

For QuickBooks Online Accountant users:

You're in luck! You can use the "Undo reconciliation" feature to make this a breeze.

1. Go to Accounting: On the left menu, click "Accounting," then "Reconcile."
2. View Your History: Select "History by account."
3. Find the Reconciliation: Choose the account and date range, then find the reconciliation you want to undo.
4. Undo It! Under the "Action" column, click the dropdown arrow, then select "Undo." Confirm your choice, and you're all set!

For other QuickBooks Online users:

You'll need to manually unreconcile each transaction. It's a bit more work, but totally doable.

1. Open Your Chart of Accounts: Click the Gear icon at the top, then select "Chart of Accounts."
2. View Your Register: Find the account you need and click "View Register."
3. Unreconcile Transactions: Look for the "R" status in the "Reconciliation" column. Click it repeatedly until it's blank or shows a "C" for cleared.
4. Save Your Changes: Click "Save" and "Yes" to confirm.

A quick word of advice: Before you make any major changes like this, it's always a good idea to chat with your accountant. They can help ensure all your records stay accurate. If you run into any issues, you can always check out the QuickBooks Online help articles for more info!

For more information on how to undo reconciliation, see this article: Undo a client’s reconciliation in QuickBooks Online Accountant.

Tip #3: How to View Past Journal Entries

Want to check a past journal entry? The easiest way is to run a Journal Report and filter it.

1. Find the Journal Report: Go to the "Reports" menu and search for "Journal."
2. Customize Your Report: Click the "Customize" button to filter the results.
3. Set the Date Range: Make sure to set the "Report period" to include the dates you need.
4. Filter by Transaction Type: Under the "Filter" dropdown, check the box for "Transaction Type" and select "Journal Entry."
5. Run the Report: Click "Run Report," and you'll see a list of all your journal entries!

From there, you can click on any amount or transaction to see all the details. Happy reviewing!