Import Expenses

You can import your expenses from a .CSV format spreadsheet. When you import expenses from a spreadsheet, your current expense items will be replaced with the items in the spreadsheet.

Your spreadsheet will need the following columns:

method: the method used to determine the value
item: a description of the item
where used: a column describing where the item is used in your solution
value: the amount you are assigning to the item

Export Expenses can be used to create a .CSV spreadsheet that contains your current expense items. You can then edit these expenses with a tool such as Microsoft Excel and then imported the amended expense items.

The method column for an expense must be one of these methods:

Method	Accepted column values (not case sensitive)
new-receipt	new-receipt receipt newr
new-estimate	new-estimate estimate newe
used / garage sale	used/garage sale used garage sale
one day rental	one day rental rent rental
trash	trash
exempt	exempt

Method and Item identify the expense. If your spreadsheet includes multiple expenses with the same method and expense pair, the last expense will be included and the others will not.

Values will be stored as a decimal number with 2 decimal places (eg 123.45). Do not include symbols such a $ as part of the value.