- 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
  • Make sure the amounts you want to import don't contain a comma to separate thousands.
  • Make sure the amounts don't contain currency symbols, such as a $ or € sign. PigMoney will automatically add the currency that you have chosen in the System Preferences. (See Setup).
  • If you can't import your data into PigMoney, please contact us. We will be happy to help you.



- 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.