Hi All - I'm guessing this has probably been discussed before, but I couldn't find anything in the knowledge base.
I am downloading a file with a detail of transactions from my credit union, in what they are calling a quicken format. Okay, so I admit, I am too cheap to just purchase quicken (it's legal for me to just use monarch to grab the data and drop it into a spreadsheet, right?!).
Here is what the data looks like:
PSAMSCLUB #6333 BANGOR ME
MWithdrawal Debit Card
PFAR REACHING MIN
MWithdrawal by Draft
PPOS SUBWAY #587 570 STILLWATER AVE BANGOR
MWithdrawal Point of Sale #061273
PPOS SHAW'S MARKET 48 353 MAIN ST BANGOR ME
MWithdrawal Point of Sale #634300
^ /font[/quote]So, it seems pretty easy. Each line has an identifier (date, transaction amount, party, etc.), and there is a ^ character after each transaction.
I am using the ^ as my detail line, and setting each of the other lines above it as an append template. Am I going in the right direction?
The problem I am having is this: not every line has the "N" field (check number). I set up a template for this field, but it is 'appending' this check number to all subsequent fields, until it comes across a transaction with a new check number.
Is there a way to work around it filling in subsequent fields? Maybe I am doing this wrong.
Any help would be greatly appreciated. Thanks!