- Importing transactions from a tab delimited text file
PigMoney can import transactions from a tab separated text file. This format can be exported from most databases, word processors and spreadsheets (e.g Filemaker, Word, Mesa, Excel,...) and from Quicken.
The columns need to be in this order: date (mm/dd/yy) / amount / category / payment method / notes.
An example file with two transactions could look like this:
11/08/02 | -1500.000000 | Apple | Computers | Visa | New iMac |
11/09/02 | -55.000000 | K-Mart | Groceries | Cash |
Notes about importing
|
|
- Importing transactions from Quicken
PigMoney can't import Quicken files directly, but you can import Quicken data by first creating a tab delimietd file and then importing it as described above.
Create a report in Quicken that includes the data you want to export.
Save the report as Excel compatible text.
Import into Excel. Edit to match the PigMoney format (see the Notes above) and save as tab delimited text.
Note: PigMoney won't import a Quicken "split". In your Quicken report, if you choose to hide the split, PM will not get the detail. If you choose to show the split, you can edit each sub-transaction in Excel to appear as separate transactions with the same date, etc.
- Exporting transactions
PigMoney can export to two file formats: tab separated text and Quicken format.