Quicken Premier Windows: Losing balance when exporting to Excel

Rusty Dockery

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

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

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

Rusty Dockery said:

… I'm not sure why that would lose a data column in the export. I…

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

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.

splasher

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

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.

Rusty Dockery

splasher: this was directly from the register. It was supposed to represent the transactions in date order with balance after each. I get your point.

Rusty Dockery

Jim: I exported in the default. I'll take a look at it. Will try again in .csv although I'm not sure why that would lose a data column in the export. I can just add a balance column to the exported file but have several to do. Mostly curious ...

splasher

Rusty Dockery said:

… I'm not sure why that would lose a data column in the export. I…

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

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.

Rusty Dockery

volvogirl, I got that. Thanks!