Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello,
In Quickbooks for Nonprofits (and Quickbooks Desktop), I am trying to find the simplest way to export the Check Register to Excel, so that I can format the report for our Board.
I see a couple different ways to get the information - 1) Tweak the balance sheet report and then export to Excel - or - 2) Once the check register is open, use the 'print' icon, select 'comma delimited file' in the print settings tab, then select the location to export the file to.
While both of the above methods will work in a roundabout way, I was wondering if there is a less cumbersome way to simply export the exact information from the Check Register to Excel.
Thank you!
Solved! Go to Solution.
Hello there, @clg3.
You can go to the Chart of Account and run a Quickreport.
Here's how:
For your reference, I recommend checking out these articles: Understand reports and Customize reports in QuickBooks Desktop.
Stay in touch if you have an additional concern. I'm always here to help. Have a fantastic day!
Hello there, @clg3.
You'll want to export your check register to Excel. From there, it'll be easy to convert the report to your specified file format. I'd be glad to guide you how.
In your QuickBooks Desktop (QBDT):
Here's an article you can read for more details in exporting reports to excel: Export reports as Excel workbooks in QuickBooks Desktop.
You can also customize the reports to show the specific data you need before exporting it to Excel. I got you this article that can guide you through the steps: Customize reports in QuickBooks Desktop.
Also, I encourage you to visit our Help articles page. From there, you can read helpful articles that can guide you in your future task.
Should you have other concerns or questions in the future, don't hesitate to reach out to us anytime.
Thanks for the quick response. What I'm actually looking for is the simplest way to export the Check Register directly to Excel. I have exported the balance sheet, but to get the info I want it takes a little extra tweaking. Ideally, I'm hoping to just export the Check Register to Excel, since it would contain the exact info I need without having to go through any extra steps.
Hello there, @clg3.
You can go to the Chart of Account and run a Quickreport.
Here's how:
For your reference, I recommend checking out these articles: Understand reports and Customize reports in QuickBooks Desktop.
Stay in touch if you have an additional concern. I'm always here to help. Have a fantastic day!
Utilize the trial period of 3rd party tool to export the data out easily.
https://transactionpro.grsm.io/qbo
You should get a XLS table like this
RefNumber | BankAccount | Vendor | PrintOnCheckName | TxnDate | Location | AddressLine1 | AddressLine2 | AddressLine3 | AddressLine4 | AddressCity | AddressState | AddressPostalCode | AddressCountry | PrivateNote | ToBePrinted | Currency | ExchangeRate | ExpenseAccount | ExpenseDesc | ExpenseAmount | ExpenseBillableStatus | ExpenseBillableEntity | ExpenseClass | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineBillableStatus | LineBillableEntity | LineClass |
101 | Checking | Joe's Coffee | 01/10/2020 | 12 Main Street | Suite 102 | Albany | NY | 12345 | N | General Supplies | General Supplies | 85.21 | |||||||||||||||||||
102 | Checking | Costco | 01/10/2020 | PO Box 1000 | Dallas | TX | 28456 | N | General Supplies | General Supplies | 125 | ||||||||||||||||||||
103 | Checking | Property Mgmt Assoc | 01/10/2020 | PO Box 1800 | Albany | NY | 12345 | Mar 2011 Rent | N | Rent | Rent | 1000 |
Thank you! This works quite well. The only difference is that I access our Chart of Accounts through "Company". I appreciate your answer!
Just to clarify - The post that I'm referring to as working the best for exporting Check Register data to Excel is the one where you go through your Chart of Accounts, select the account, right-click and select QuickReport. Thank you to everyone for their suggestions.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here