Re: [GNC-dev] Import PDF to GnuCash
deltatango, How does Quickbooks use the imported information from a statement? The only normal use I can think of is reconciliation of the account. For importing information I by far prefer OFX with csv as a fallback for those institutions which don't provide OFX files (Paypal is a standout here). For reconciliation, I usually prefer a printed copy so I can tick transactions off as I reconcile them in GnuCash. I have used spreadsheets as well to mark off reconciled transactions where the statement was available in csv. David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] Import PDF to GnuCash
On 7/26/2018 2:56 PM, deltatango wrote: > Hello, > > Very interested in the possibility of importing PDF statements into GnuCash. > > I know Quickbooks now has this functionality. > > I searched online and found a few clunky possibilities that would convert > the data into excel which can then be converted to csv and then imported > into GnuCash. > > I was envisioning a system where you select a PDF statement to be imported. > > The program then asks you to select the area of the statement which contains > the transactions, much like a photoshop selection. (And perhaps you could > save templates of selections for different statements). > > Then some kind of OCR scanning reads the columns and data and convert it to > columns/rows. > > Is this in the realm of possibility for some future release? > > It is so common now that exporting csv or qfx ,etc files from your bank only > go so far back and you have to download PDFs instead... > > I dream, I hope... > > But in vain I wish not... > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html > ___ > gnucash-devel mailing list > gnucash-devel@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > . > I don't think this is an option with PDF files in the near future. Adobe has gone to great effort to make sure that all of the user friendly features of PDF reader are now a paid feature. Quickbook$ can afford to add this feature because of the high fees they charge you for "improvements and features". As Jim DeLaHunt mentioned you might find some AI/Auto-learning software to convert it to a usable format, though I wouldn't hold my breath at this time. Right now, the only suggestion I can offer, other than finding another type of input file, is to print the PDF and then scan it with OCR software so you can try to extract the information you are after. --JEffrey Black M.B.A. ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] New balsheet (and P report), API considerations, and (slow?) KVP in Account.cpp
Latest iteration of balsheet * restored amount-indenting. IMHO this is now producing sane indenting for any subtotal strategy * restore dual columns (i.e. left=asset/income, right=liability/expense) * the above two only enabled when multicols are disabled * option to toggle amount/account indenting * incorporated bug 623381 recommendations for sections labels/totals * added sections for equity, liability+equity * modify 'original-currency' display to match eguile report i.e. smaller font, precedes converted currency I would really like feedback on * accuracy of amounts * accuracy of sections o further tweaking of option names/sections/ordering Screenshot: https://screenshots.firefox.com/nhaiX1ehSA2GXA97/null On 25/07/18 15:53, Frank H. Ellenberger wrote: Am 19.07.2018 um 13:09 schrieb Christopher Lam: Hi Frank Thank you - I can restore the dual-columns when the periods have been disabled. I'd prefer to limit the number of options; so, if the "period duration" is disabled, the report will automatically show dual columns while intl. IFRS and DE-GOB/HGB reqire one, US-GAAP requires 3 previous years in the Income statement. https://de.wikipedia.org/wiki/Gewinn-_und_Verlustrechnung#Vorjahresbetr%C3%A4ge (Asset/Income=left, Liability+Equity/Expense = right). This works? Can you please show me good examples of idealised T-account balance sheet/income statement? Or the scaled form? I have no idea. To get an impression you could starting from: https://en.wikipedia.org/wiki/Balance_sheet - which has #US_small_business in account form and #Sample in scaled form - or https://en.wikipedia.org/wiki/Income_statement and an example in account form: https://debitoor.de/lexikon/gewinn-und-verlustrechnung-guv Note: There are several different methods for grouping the positions with differrent pros and cons allowed for different company types: Gesamtkostenverfahren, Umsatzkostenverfahren & IFRS. Currently I have no better idea for the grouping than adjusting the account structure. Optionally select other languages e.g. https://de.wikipedia.org/wiki/Bilanz#Aufbau_der_Bilanz HTH Frank ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel