[GNC] Importing single transactions to separate deposits and withdrawals
David Carlson
david.carlson.417 at gmail.com
Mon Apr 28 09:45:47 EDT 2025
The reason I asked about OFX/QFX is because there is at least one credit
card out there that my wife likes to use which has the values reversed so
they all need to be manually changed either before or after the import.
On Mon, Apr 28, 2025 at 8:40 AM David Carlson <david.carlson.417 at gmail.com>
wrote:
> For CSV imports, if GnuCash is a recent release, 5.10 or so, the answer is
> simple. Either choose Amount or Amount (Negated) for the value column. If
> the transactions come in wrong, choose the other. Then be sure to save the
> settings with a unique name. The help description in the tutorial seems to
> be out of date.
>
>
>
> On Mon, Apr 28, 2025 at 8:17 AM Paul-A <pda+ at sdf.org> wrote:
>
>> The format is CSV... not sure if I follow your later suggestion,
>> but will give it a try to see what I get.
>>
>> On Mon, Apr 28, 2025 at 01:14:21AM -0500, David Carlson wrote:
>> > Paul-A,
>> >
>> > The possible solution would be different for each type of import.
>> Please
>> > tell us if you can import in OFX or QFX format, QIF format or CSV
>> format.
>> >
>> >
>> >
>> > On Mon, Apr 28, 2025 at 12:35 AM Paul-A via gnucash-user <
>> > gnucash-user at gnucash.org> wrote:
>> >
>> > > I had a bank account, thankfully only for a few months, that exported
>> > > debits and credits as negative and positive values in the same column.
>> > >
>> > > I suppose it'll be easy enough to massage this through awk or perl for
>> > > import into gnucash, but might there already be some canned solution
>> to
>> > > handle this situation?
>>
>
>
> --
> David Carlson
>
--
David Carlson
More information about the gnucash-user
mailing list