Skip to main content
D
dharker
March 5, 2024
Question

Profit and Loss Excel Export - certain accounts not lining up in right column

  • March 5, 2024
  • 2 replies
  • 0 views

When we export a profit and loss statement to Excel, all of the accounts except a few line up in column F, but some populate D and E - we are trying to figure out how to get these accounts to download in column F.  Thanks for any help out there.

2 replies

R
RheaMaeH
March 5, 2024

Hello there, dharker. I'm here to help you line up the accounts correctly while exporting the Profit and Loss report to Excel. 

 

First off, let's ensure that your Excel is updated. Outdated Excel versions can cause errors while exporting reports. 

 

Here's how :

 

  1. Open the Excel file.
  2. Navigate to the File menu. 
  3. Select Account. 
  4. Click Update Options.
  5. Select Update Now 

 

Also, your company file must be free from any damage or issues. Let's run the Verify and Rebuild Data tool in QuickBooks Desktop. This  scans your data and fixes any issues it finds.

 

Moreover, if you enter or change transactions in QuickBooks after exporting to Excel, you can update your report with the latest information.

 

Here's how:

 

  1. Make sure your QuickBooks company file is open. 
  2. In Microsoft Excel, go to the QuickBooks tab. 
  3. Click Update Report to get the latest version of the report. 

 

For future reference, you can read this article can guide you through the steps to generate a report that shows the information you need: Customize reports in QuickBooks Desktop.

 

If you have other concerns about exporting reports in your QuickBooks Desktop account, please let me know. I'm here to help you. Stay safe and well.

D
dharkerAuthor
March 5, 2024

I appreciate the reply - we have tried all that.  See attached PDF for the issue I am referring to that only applies to select accounts.  You see how depreciation and interest are in a different column than the accounts above?

JoesemM
JoesemM
March 5, 2024

I appreciate the steps you've performed to fix the alignment issue, Dharker. Perhaps we could explore another step that may help us perfectly align the details in your Excel file.

 

When in the Excel option, you can click the Advanced settings to make sure the format aligns exactly. Let me guide you on how:

 

  1. Go to the Reports menu.
  2. Scroll down to Company & Financial.
  3. Choose Profit & Loss Statement, then apply the appropriate customizations.
  4. Click the Excel button, then choose Create new worksheet.
  5. Tap Advanced, then tick the Fonts, Colors, Space between columns, Row height, Autofit, Freeze panes, Show Gridlines, Auto Outline, and Show report header checkboxes.
  6. Hit OK once you're done.

 

Once you save the file, we'll have to use a macro-enabled workbook. Please know that QBDT reports often contain complex calculations, formatting, and interactivity that are specific to the application. Macros help guarantee that these features will still work after they're exported. For more details about exporting reports, open this article: Export reports as Excel workbooks in QuickBooks Desktop.

 

Additionally, I've added these articles that'll help you learn more about reports and help you modify them:

 

 

Please let me know how things turn out. If you have any additional questions about aligning the details in your Excel file or anything else relating to QuickBooks, I'm always here to lend a hand. Be safe.

Terms & ConditionsAccessibility statement