Sending file to accountant
Elinor
I want to send a copy of my 'fiscal year" to my accountant. I start with export - and then send file as an attachment; however, he is unable to open the file. What should I do so that he can open the file?
Comments are currently closed for this discussion. You can start a new one.
2 Posted by james f on 19 Jul, 2012 11:59 AM
What file format are you using?
If you haven't tried it yet, try exporting as a Tab delimited file, naming it something.xls . You want to use the .xls for compatibility with Microsoft Excel data base program.
3 Posted by -Kevin N. on 19 Jul, 2012 01:43 PM
Hi Elinor,
You may also want to try creating a report of your fiscal year finances. Perhaps the Income and Expenses Report. You could then use the 'Save' option to save the report in one of the available file formats.
HTH -Kevin N.
4 Posted by Elinor Garely on 19 Jul, 2012 04:35 PM
Sounds like an excellent idea. How do I do this? I cannot find any area
called "Report"
/eg
Dr. Elinor Garely
Support Staff 5 Posted by Scott Meehan on 19 Jul, 2012 04:42 PM
Hi Elinor,
You can get to the reports and graphs section of Moneydance by scrolling down on the sidebar on the left, where your accounts are. If you scroll down far enough, you'll find the Income and Expenses report that Kevin was referring to, and also the Income and Expenses, Detailed report may be helpful.
Please let us know if we can be of further assistance!
Scott Meehan
Moneydance Support
6 Posted by -Kevin N. on 19 Jul, 2012 04:55 PM
Hi Elinor,
You should also be able to access the Income and Expense reports from the Moneydance Menu bar. Click on Tools, then click on the Graphs and Reports menu item.
From the resulting form, select the desired report from the list on the left, set the desired parameters from the choices on the right and click 'Generate'.
HTH -Kevin N.
7 Posted by Elinor Garely on 01 Aug, 2012 04:28 PM
James,
I am trying to
1. Print my income/expense report
2. Send the information to my account with an MD extension
I am unable to complete either step one or two
Can you please tell me what to do?
Thank you.
/eg
Dr. Elinor Garely
8 Posted by -Kevin N. on 01 Aug, 2012 08:49 PM
Hi Dr. Garely,
Open Moneydance to your Income & Expense Report.
In the upper right-hand corner are several buttons. One of which is 'Print' and one of which is 'Save'.
See the attached screenshot.
1) To print the report, click 'Print' to open the printer dialogue box allowing you to select the parameters of the print job.
2) To save the report, click 'Save'. In the resulting dialogue box, choose a Format from the drop-down list that your accountant can read (probably Comma Delimited)
Click the 'Browse' button.
An Explorer window will open.
Navigate to where you want to Save the file.
Name the file as desired making certain to retain the .CSV extension.
You can then email the .CSV file to your accountant as an attachment.
HTH -Kevin N.
9 Posted by Elinor Garely on 02 Aug, 2012 02:33 PM
I followed your instructions (step 2) however, I was unable to locate the
CSV extension - so the document lost all formatting.
Other suggestions will be appreciated.
eg
Support Staff 10 Posted by Jon Hoover on 02 Aug, 2012 02:46 PM
Elinor,
In step two after you have selected 'comma delimited', you will press the browse button to find a location for the file. The file should already have as part of the name '.csv', just make sure that when you are naming it you retain the '.csv' part.
Does this help to clarify things?
Sincerely,
Jon Hoover, Moneydance Support
11 Posted by Elinor Garely on 02 Aug, 2012 03:10 PM
No - when I save the csv does not appear.
eg
Support Staff 12 Posted by Jon Hoover on 02 Aug, 2012 03:22 PM
Hi Elinor,
Are you going to the file menu at the top left and selecting File- > Save or are you pressing the 'Save' button at the top of the report in between 'print' and 'memorize'.
Sincerely,
Jon Hoover, Moneydance Support
13 Posted by Elinor Garely on 02 Aug, 2012 03:30 PM
I am using the File /Save at the upper right hand side of the screen -
above the report.
It is saving the file but all formatting is gone
.eg
Support Staff 14 Posted by Jon Hoover on 02 Aug, 2012 03:34 PM
Hi Elinor,
What do you mean that all the formatting is gone? What program are you trying to open it in, how does it look in there?
Thanks.
Sincerely,
Jon Hoover, Moneydance Support
15 Posted by Elinor Garely on 02 Aug, 2012 03:37 PM
This is what it looks like when I open it:
Income and Expenses, Detailed
01/01/2011 - 12/31/2011
Category,Date,Account,Description,Amount
INCOME,,,,
Investment,,,,
,04/24/2011,Cash,Citibank,13934.04
Dividends,,,,
,02/18/2011,Checking,Comcast,16.88
,11/22/2011,Checking,Comcast,16.88
Dividends - TOTAL,,,,$ 33.76
Investment-Other,,,,$ 13 934.04
Investment - TOTAL,,,,$ 13 967.80
Other Income,,,,
,02/18/2011,Checking,TASA,3325.00
,02/24/2011,Checking,Guardian Life,25.00
,11/26/2011,Checking,Lovett,350.00
,11/30/2011,Checking,Miscellaneous,57.07
Consulting Payment,,,,
,02/21/2011,Cash,TASA,-572.25
Consulting Payment - TOTAL,,,,$ -572.25
Other Income-Other,,,,$ 3 757.07
Other Income - TOTAL,,,,$ 3 184.82
Retirement Income,,,,
Social Security,,,,
16 Posted by Elinor Garely on 02 Aug, 2012 03:54 PM
I think I sent this a few minutes ago - but just in case:
This is what it looks like when I open it:
>
>
> Income and Expenses, Detailed
>
> 01/01/2011 - 12/31/2011
>
>
>
> Category,Date,Account,Description,Amount
>
> INCOME,,,,
>
> Investment,,,,
>
> ,04/24/2011,Cash,Citibank,13934.04
>
> Dividends,,,,
>
> ,02/18/2011,Checking,Comcast,16.88
>
> ,11/22/2011,Checking,Comcast,16.88
>
> Dividends - TOTAL,,,,$ 33.76
>
> Investment-Other,,,,$ 13 934.04
>
> Investment - TOTAL,,,,$ 13 967.80
>
> Other Income,,,,
>
> ,02/18/2011,Checking,TASA,3325.00
>
> ,02/24/2011,Checking,Guardian Life,25.00
>
> ,11/26/2011,Checking,Lovett,350.00
>
> ,11/30/2011,Checking,Miscellaneous,57.07
>
> Consulting Payment,,,,
>
> ,02/21/2011,Cash,TASA,-572.25
>
> Consulting Payment - TOTAL,,,,$ -572.25
>
> Other Income-Other,,,,$ 3 757.07
>
> Other Income - TOTAL,,,,$ 3 184.82
>
> Retirement Income,,,,
>
> Social Security,,,,
>
> On Thu, Aug 2, 2012 at 11:35 AM, Jon Hoover <
> [email blocked]> wrote:
>
17 Posted by -Kevin N. on 02 Aug, 2012 04:14 PM
Hi Elinor
If you want to save the fie with the formatting of the report in tact then try saving the file as HTML instead of Comma Delimited.
Open Moneydance to the Income & Expense Report.
Click the 'Save' button in the upper right.
Select HTML as the Format.
Click 'Browse'.
Navigate to where you want to save the file.
Make sure that if you rename the file that you retain the .html extension.
I've attached a screenshot of the Explorer window that opens when you click the 'Browse' button. Note the .html extension of the filename.
HTH -Kevin N
18 Posted by Elinor Garely on 02 Aug, 2012 04:42 PM
I think this will work! Thank you.
It saved correctly - now I just hope that it can be opened and retain
format on the computer of my accountant.
/eg
19 Posted by -Kevin N. on 02 Aug, 2012 05:11 PM
Hi Elinor,
You're welcome. I'm glad to hear that it appears to be sorted out.
Your accountant may be more concerned with the raw data contained in the .CSV file over the pretty formatting of the .HTML file. If I may make a suggestion, perhaps you should send him / her both files.
HTH -Kevin N.
20 Posted by Elinor Garely on 02 Aug, 2012 05:23 PM
I do appreciate your patience.
My account was able to open the html version.
*What I did not understand (and just guessed) - that I had to write html
after the save as*
I thought it should show up (who knew?"
Thank you so much.
/eg
Support Staff 21 Posted by Angie Rauscher on 02 Aug, 2012 06:28 PM
Glad to hear it's worked out with the report, and I'm sorry to hear you had such difficultly. If you need anything else, do let us know.
Angie Rauscher
Moneydance Support
22 Posted by Elinor Garely on 02 Aug, 2012 06:35 PM
I am appreciative of your patience!
Thank you.
/eg
Angie Rauscher closed this discussion on 02 Aug, 2012 07:54 PM.