Regarding loose cannon with debit card, convert them to using a credit card? Essentially free credit so long as you pay it off every month. Then you only have to deal with it once every month.
The GnuCash matcher isn't perfect, but it works well. Kind regards, Greg Feneis (Pixel 3) On Sun, Oct 18, 2020, 12:35 Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > On 10/18/20 12:51 PM, Fran_3 via gnucash-user wrote: > > David, thanks for the comments. > > I'm going to experiment more with the import matcher. > > I have discovered this time saving tip... we can... > > > > - Log on to our bank, drag the mouse over the transactions, and copy > into the paste buffer > > - Then paste them directly into a Google Sheet...- Thus avoiding the > downloading and importing a CSV file. > > Why *not* download the CSV? That saves many, many clicks and drags. You > just open it in Google Sheets and the data is all there. > > > Ditto for GnuCash Checking if we bring it up in a Transaction Report > > And, as I mentioned to Adrien, I have created an App Script to help me > compare the Bank Transactions to the GnuCash TransactionsThe process...- > Sort the Bank Transactions by Amount and then by date- Ditto for the > GnuCash Transactions > > - Put both Bank & GnuCash transactions on the same sheet- Drag the > Amount Columns of each so they are side by side- Insert a column between > the two Amount Columns- Create a spreadsheet formula to put an "X" in the > column if the amounts don't match- Copy that formula all the way down to > the last row- Now you can see where inconsistencies occurIt gets tricky now > however so this is where I wrote an App Script to copy either the Bank > Transactions or the GC Transactions starting with the inconsistency... and > move them down a row... and then re-run the matching formula. > > Normally, too much work... but in one case where I just rechecked the > reconciliation of 3-years worth of transactions... it was helpful. > > There are other, maybe easier ways to do this I'm sure. > > You *could* script a comparison with the transactions exported from GC. > I think there is now also a command-line interface that might be able to > grab the data. Look into something called PieCash. (not sure of > spelling) It was created as a Python interface to the GnuCash data file. > (for reading only, always 'edit' or 'create' transactions using GnuCash > itself) > > Also look into OFX from your bank. You can set up GnuCash to connect to > the bank and grab the transactions directly. (But I'd stand by my > recommendation to improve purchasing procedures and if at all possible > get receipts for everything so you can enter them and then the bank > procedure will be for clearing only) > > Regards, > Adrien > > _______________________________________________ > 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.
