cancel
Showing results for 
Search instead for 
Did you mean: 
dolosc1094
Level 1

Quickbooks self employed. no way to download a general ledger for a month in excel? Only profit loss in adobe. this does not help.

 
9 Comments 9
cbs-csslaw
Level 1

Quickbooks self employed. no way to download a general ledger for a month in excel? Only profit loss in adobe. this does not help.

If you are on QuickBooks Online:  Go to reports, use the search bar and type in General Ledger.  Enter.  It will create a report.  Scroll all the way to the top of the report and you can customize the dates you want.  Click Run Report.  Go to the icons at the top right and hit the one with the box and curved arrow.  Choose export to Excel.  That should export the data for you and you will be able to work with it in Excel.

MaryLandT
Moderator

Quickbooks self employed. no way to download a general ledger for a month in excel? Only profit loss in adobe. this does not help.

Hi there, dolosc1094,

 

Adobe file is the default when downloading reports in QuickBooks Self-Employed.

 

You can select another format from the drop-down list upon opening the file. This is to ensure you're able to open it in Excel. 

 

Let me show you how;

  1. Go to Reports from the left navigation bar.
  2. Select a period.
  3. Click the arrow, then choose Download.
    downloadQBSEreport.PNG
  4. Select Other from the Open with drop-down menu, then choose Excel.
    downloadQBSEreport1.PNG
  5. Click OK.
  6. If it isn't showing up on the list, you can look for an application that can convert a PDF file to Excel. 

You can also refer to the Reports link so you can customize, run, and share financial statements.

 

Don't hesitate to leave a comment below if there's anything else you need. I'm always glad to help you out.

Jrlawr
Level 1

Quickbooks self employed. no way to download a general ledger for a month in excel? Only profit loss in adobe. this does not help.

When you click download, it immediately downloads a PDF.  No other option.  

MaryLandT
Moderator

Quickbooks self employed. no way to download a general ledger for a month in excel? Only profit loss in adobe. this does not help.

That's right, Jrlawr.

 

Reports from QuickBooks Self-Employed are downloaded in PDF format. 

 

There are a few ways to get transaction info in QuickBooks Self-Employed. You can go to the Reports menu and run financial reports. Or, if you want a detailed list of all your transactions, you can export them into a CSV file.

 

Run financial reports:

  1. Go to the Reports menu.
  2. Find the report you want to download.
  3. Select the time period or tax year from the drop-down.
  4. Click View or Download.
  5. Select the arrow icon ▼, then the Print or Download.
     

Download your transactions:

  1. Go to the Transactions menu.
  2. Use the TypeAccount, and Time period ▼ drop-down to sort the transactions.
  3. Select the Export icon.
     

If you need to make changes or reorganize your transactions, it's best to do it in QuickBooks Self-Employed.

 

If you reimport the CSV, you need to recategorize your transactions after you import. Doing this will help ensure your taxes are accurate.

 

Stay in touch with me if there are other things you need in QBSE. I'll be around to provide the information.

aara22
Level 1

Quickbooks self employed. no way to download a general ledger for a month in excel? Only profit loss in adobe. this does not help.

How is there no way to download a .csv file? This is insane.

JasroV
QuickBooks Team

Quickbooks self employed. no way to download a general ledger for a month in excel? Only profit loss in adobe. this does not help.

Nice to have you joined this thread, @aara22.

 

QuickBooks Self-Employed (QBSE) downloads your report to PDF file as default. You can only download your Transactions and Tax Details as MS Excel file

 

Also, importing a .CSV file is only available in uploading bank transactions. I see how beneficial it is to your business to download a report as a .csv file. Rest assured, our Product team is always looking for ways in improving QuickBooks to help our users run their business seamlessly.

 

In the meantime, you'll want to look for a converter tool that lets you convert your .pdf file to Excel and .csv. Moreover, to stay updated on the latest news and updates about QuickBooks, I recommend checking our QuickBooks Blog page. 

 

I've also collected these links that you can read for guidance in filing your tax:

 

 

Tag me in your reply if you have other concerns exporting your reports. I'm just a post away from you. Keep safe!

JJMF
Level 1

Quickbooks self employed. no way to download a general ledger for a month in excel? Only profit loss in adobe. this does not help.

Absolute insanity. My mistake to just assume that this would have been an option. Actually renders this almost useless for me. 

foxmassagellc
Level 1

Quickbooks self employed. no way to download a general ledger for a month in excel? Only profit loss in adobe. this does not help.

There is no search bar when I click on the reports tab. No way to find "General Ledger." What's the deal with this?

AbegailS_
QuickBooks Team

Quickbooks self employed. no way to download a general ledger for a month in excel? Only profit loss in adobe. this does not help.

Hi there, @foxmassagellc.I understand how important it is for you to have access to this feature when accessing your report, and I'm here to assist you.

 

Usually, unexpected behavior within the system is caused by browser-related issues. Regular browser stores cache files that make frequently accessed sites such as QuickBooks don't function well. To help resolve this issue, I can provide you with some troubleshooting steps that may help bring back the search bar on the Reports tab. To begin, open your account incognito. Private mode will give you a clean slate to prevent errors when running websites.

 

Below are the keyboard shortcuts you can use:

 

Google Chrome: Ctrl + Shift +N

Mozilla Firefox and Microsoft Edge: Ctrl + Shift + P

Safari (latest version): Command + Shift + N

 

If it works, you’ll want to clear your main browser’s cache. By doing so, it can help the program run faster and more efficiently. You can also use other supported browsers except for Internet Explorer as an alternative.

 

To learn how to export transactions and run reports in QBSE, see this article for detailed steps: Export Transactions and Get Reports In QuickBooks Self-Employed.

 

To give you more idea about the QBSE program, visit this helpful link: QuickBooks Self-Employed Overview.

 

Feel free to post a reply If you need further assistance. The Community will be glad to help you. Keep safe, and have a good one!

Need to get in touch?

Contact us