Request assistance for importing invoice/bill payments

[Derek Atkins]

Hi,

Nelson Handcock <nelson.handcock at gmail.com> writes:

> Hello Geert,
>
> Thanks for responding. As per my screenshots on my dropbox (refer to my
> original email). - I am successfully importing Bills and Invoices using the
> importer tool, and I'd like to do similar with payments for the
> transactions.

Unforuntely there is an importer for bills and invoices, but there is no
importer for "payments".

[snip]
> The "Assign as Payment..." does literally nothing. I am in the list of
> transactions for the Expenses:Accounts Receivable account - I highlight a

And *THIS* is your problem.   The imported payment is going to EXPENSES
and not ASSETS.  The payment is from ASSETS:A/R to Cash, not from
EXPENSE (or Income).  That's why the "Assign" isn't working.

[snip]
> When I used the qif importer it automatically creates entries in the
> Expenses and Income accounts. With the csv transaction importer I expect I
> will have to build both these transactions separately, and maybe even have
> them in separate import files (one for each account).

You're just putting them into the wrong place.

> So at this stage the qif importer looked to be the better tool (2
> transactions based on a single data source - no mucking around getting the
> data into the correct columns, etc).

It is, IMHO, the "better tool."   :)

> I've exported transactions into a csv file and I imagine I'd have to build
> a csv file that has the same layout to use for imports. I'm happy to
> explore the transaction importer approach more, if that's going to be the
> best thing to do.
>
> Your advice will be appreciated...

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available