Re: [GNC] Import Format

[DaveC49]

The developers' link looks interesting. It seems to be mainly about making
authorized payments for e-commerce functions on a quick look at it and
nothing about downloading transaction data, but it is a move in the right
direction. 

The Python version of the API may provide a way of creating a payment system
which interfaces with GnuCash though the GNuCash Python API to automatically
record the transactions made in the books. The API uses OAuth2
authorisations so it  will be at least that secure.  The CBA seems at last
to be starting to catch up with the times.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import Format

[flywire]

Sample pdf bank statement attached. Format will vary by bank but note
"Opening balance" before first transaction, "BALANCE CARRIED FORWARD" at end
of non-last page, "BALANCE BROUGHT FORWARD" at start of non-first page and
"CLOSING BALANCE" on last page would allow transaction filtering.

Some programs recognise field layout in pdfs supporting export to csv
although Transaction descriptions are split over multiple lines and likely
end up in different records.

Commonweath_Bank_Statement.pdf

  



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import Format

[flywire]

Another two of the four Australian banks:

*
https://help.anz.co.nz/app/answers/detail/a_id/334/~/transaction-history-export-formats
*
https://www.westpac.com.au/business-banking/online-banking/support-faqs/export-detailed-transaction-history/

Don't assume these formats are available with all accounts.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import Format

[flywire]

Thanks Dave, that's one of the four main banks:
https://commbank.simplify.com/commerce/docs/misc/dataexport

Interestingly there's a developer's link on that page too.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import Format

[peterb]

On a related note, I wish Gnucash supported export formats besides CSV.

-p


On Thu, May 27, 2021 at 9:39 PM DaveC49  wrote:

> The CBA in Australia offers CSV, OFX and QIF (2 variants) downloads from
> the
> bank website. They only offer direct connect OFX downloads via MYOB or
> Quicken where these companies have a software deal/agreement with the bank
> about security. i have approached them about direct connect access but
> received a blanket no for open access software. Not sure about other
> Australian banks and what they offer.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import Format

[DaveC49]

The CBA in Australia offers CSV, OFX and QIF (2 variants) downloads from the
bank website. They only offer direct connect OFX downloads via MYOB or
Quicken where these companies have a software deal/agreement with the bank
about security. i have approached them about direct connect access but
received a blanket no for open access software. Not sure about other
Australian banks and what they offer. 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Import Format

[flywire]

The documentation could offer users more guidance in choosing the import
format.

Most banks allow account transactions to be downloaded (usually as files)
and most financial software (including GNUCash) allows the transactions to
be imported. GnuCash offers six options but in reality the user might only
have one or two formats available from the bank.

I understand OFX/QFX is the preferred format but likely only available in
USA. It seems MT940 and MT942 SWIFT and DTAUS format (DTAUS has not been
supported by banks since 1 February 2016) would also be a preferred option
if available.

In Australia and probably most other parts of the world the likely options
are CSV and/or QIF. QIF is probably the preferred of the two and although
the date format can never be known it's probably reasonable to assume it
matches the locale setting. (Note: GnuCash does not support date formats
with Mmm.) CSV is a loose format the user will need to specify. One
advantage of these formats is they are fairly easy to manipulate,
particularly CSV.

A last resort worth mentioning is extracting data from pdf files, probably
manipulating in a spreadsheet and converting into CSV format. Users would
need to work this process out themselves.

References: 

https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-MT940-MT942-DTAUS
 
https://gnucash.org/viewdoc.phtml?rev=4=C=help 
https://gnucash.org/viewdoc.phtml?rev=4=C=guide 
https://en.wikipedia.org/wiki/Open_Financial_Exchange 
https://en.wikipedia.org/wiki/Quicken_Interchange_Format 
https://en.wikipedia.org/wiki/Comma-separated_values 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.