Request assistance for importing invoice/bill payments

[Nelson Handcock]

Thanks Derek - I'll look into your suggestions further as soon as I can,
and will let you know how I get on.

Thanks & Regards,

Nelson Handcock

<http://www.linkedin.com/in/nelsonhandcockaustralia>

On Mon, Sep 29, 2014 at 10:11 AM, Derek Atkins <warlord at mit.edu> wrote:

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