Export items with multiple categories
Posted: 22 March 2009, 23:20
Thank you for a fantastic product. In two days I have my finances almost sorted! After months of trying to get it together!
I just have two questions....
- I want to use iCompta to track all of my finances, including work expenses
- I tag my entries in iCompta with various categories (eg. food or travel) for my personal budgeting. But...
- Occasionally I also spend money for work (e.g Fuel, or buying something at the supermarket). So I tag these entries with 'Work Expense'
- Then at the end of the month, I need to take all 'Work Expenses' into excel, to fit into a standard 'Expense Claim Form' that my work has.
- In Excel, I just filter out the items tagged with the 'Work Expenses' category
- So far... all this works well, but now comes my problem:
- When I tag an entry with multiple categories (which is a fantastic feature), and split the cost across both, then I can't get that info in Excel.
- To explain, I may have purchased some food at the supermarket, and a cable for work, so I add 2 categories ('Food' with $25.00 and 'Work Expense' with $4.50)
- When I export to csv, then into excel it comes out as one line of $29.50 with the category 'Food'
So... my questions....
1) Is there a way to export just the entries I want (eg 'Work Expense')?
2) Is there a way to show the actual amount assigned to that category as a single line item in a csv?
I hope this all makes sense.... sorry, I only speak english, so I couldn't search the forums.
Best Regards,
Antony Pritchett
I just have two questions....
- I want to use iCompta to track all of my finances, including work expenses
- I tag my entries in iCompta with various categories (eg. food or travel) for my personal budgeting. But...
- Occasionally I also spend money for work (e.g Fuel, or buying something at the supermarket). So I tag these entries with 'Work Expense'
- Then at the end of the month, I need to take all 'Work Expenses' into excel, to fit into a standard 'Expense Claim Form' that my work has.
- In Excel, I just filter out the items tagged with the 'Work Expenses' category
- So far... all this works well, but now comes my problem:
- When I tag an entry with multiple categories (which is a fantastic feature), and split the cost across both, then I can't get that info in Excel.
- To explain, I may have purchased some food at the supermarket, and a cable for work, so I add 2 categories ('Food' with $25.00 and 'Work Expense' with $4.50)
- When I export to csv, then into excel it comes out as one line of $29.50 with the category 'Food'
So... my questions....
1) Is there a way to export just the entries I want (eg 'Work Expense')?
2) Is there a way to show the actual amount assigned to that category as a single line item in a csv?
I hope this all makes sense.... sorry, I only speak english, so I couldn't search the forums.
Best Regards,
Antony Pritchett