Quicken Premier Windows: Losing balance when exporting to Excel

Question

When I export last years transaction register, all columns appear in the Excel file except the balance after each transaction. Am I doing something wrong? Need to send to CPA. Thanks!

splasher · Accepted Answer

I don't think your CPA has any use for the balance column because if you remove/change any entry, that column would be wrong and meaningless.I don't know which report you are running, but my Banking->Transaction report doesn't have a running balance column.

Jim_Harman · Accepted Answer

What type of account is this? If a banking account, you should be able to print or export the register by viewing the register then hitting Ctrl-P or picking File > Print. This is also the case for the running cash balance in an investing account, unless it is a Single Mutual funf account which cannot hold cash or it is set to show its cash in a checking account.

For best results when exporting to Excel, choose the PRN (123 compatible) format and give the file a CSV extension. Despite its name, this will produce a CSV file which you should be able to open directly in Excel.

splasher · Accepted Answer

To clarify, the balance is not a stored data column, it is a calculated column .  If it was a data column, changing a transaction's amount would require the balance in all subsequent transactions to re recalculated and stored which would slow things down greatly.

volvogirl · Accepted Answer

When you get it open in Excel just add the balance column yourself and enter the formula going down all the cells.  Do you need help writing the formula?  It would be the prior line balance + deposit - payment.  So you might need to enter a beginning balance or zero at the top to start.