Re: [GNC] Import csv, ofx

Thank you for the prompt response. A clarification please, what does "AFAIK" stand for and I also use Libre Office these days, after using Open Office and Quattro Pro for years, never did use Excel. Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile

Re: [GNC] AqBanking Online Set Up

YAS! General Journal Register ftw! woot! Even imported five bank accounts. Okay so now I manually click the amounts to correct account. Sweet! Wish I was using GNU Cash Years ago. On Tue, Jan 4, 2022 at 1:28 PM John Ralls wrote: > Yup, 10 months: > 2021030112[-8] >

Re: [GNC] Trial Balance Report Settings

I think the OP is looking to save the settings from one iteration to the next, which I'd achieve by saving the settings as "My Trial Balance" and then calling that report whenever I needed it. Original Message From: Jesse MacDougall Sent: Tue Jan 04 20:19:08 EST 2022 To:

Re: [GNC] Import csv, ofx

Gyle, Export it as Excel, load it up in Excel and export it from there as CSV. GnuCash has always read Excel's CSV exports AFAIK (I use Libre Ofiice these days and it certainly works with LO). You should also be able to set the date format in the CSV import dialog. It will likely default to the

Re: [GNC] Trial Balance Report Settings

Yes i saw a setting for this somewhere dont recall exactly On Tue., Jan. 4, 2022, 16:41 Benjamin Soffer, wrote: > Hello, > > Is it possible to configure the trial balance report so that hidden > accounts or zero-balance accounts would be excluded from the report? > > Ben Soffer >

[GNC] Import csv, ofx

I have been having a great experience importing ofx files for my bank accounts and credit cards. However, when I tried to export from Discover Card, the only options were Excel or csv. I didn't see that Gnucash imported Excel so I used csv. I had absolutely no luck importing the csv file

[GNC] Trial Balance Report Settings

Hello, Is it possible to configure the trial balance report so that hidden accounts or zero-balance accounts would be excluded from the report? Ben Soffer ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences

[GNC] Tax question - gross income for the year

Hello, I'm having an issue in transaction report in easily seeing gross income for the year. Specifically: 1. I have Income:Sales and when I do an invoice, I direct income to go there. 2. Sometimes clients reimburse me for postage charges, so that does not go to income:sales but is in

Re: [GNC] Cash Basis Accounting

On Tue, 4 Jan 2022, Don Gray wrote: The problem stems from the report being off by several thousand dollars as I’ve posted invoices but not received the payments. Don, What I do, on the advice of my previous accountant who's now retired, is not to enter an A/P or A/R invoice until payment is

Re: [GNC] Cash Basis Accounting

I normally re-post invoices to the 1st of the year if not paid before, and any bills that are due and paid after the year end I also post to the 1st. Rarely do I find something that needs to be moved the other direction (although it is possible, I just can’t think of an instance off hand).

[GNC] Cash Basis Accounting

For 2021 year end account I need to generate a profit/loss report. No problem as a standard report exists. The problem stems from the report being off by several thousand dollars as I’ve posted invoices but not received the payments. Searching the internet I found

Re: [GNC] GNUCash 4.9

Glad to hear you resolved it, thanks for reporting back what worked. Regards, Adrien On 1/4/22 10:53 AM, Steve Mortimer wrote: What I did to correct my problem was to take the last backup file and remove all of the dates in the file name and made that my main (orginial) transaction file.  I

Re: [GNC] A repository for user-contributed files

I'd say more like 'ask' or 'request' or 'inform' people about that method in the Wiki. And while it has been some time, I think that method does work. I used to use it for a spell and I don't recall un-threading issues. But further confirmation would be needed. Regards, Adrien On 1/4/22

Re: [GNC] show unposted invoices in customer report?

On 1/4/22 12:24 PM, Derek Atkins wrote: Feel free to write a new report and submit it to the team for inclusion. In 20 years, you're the first person to ask for this. Maybe not to this level of detail, or with this specific solution/suggestion, but the basic question I've seen several times,

Re: [GNC] AqBanking Online Set Up

Yup, 10 months: 2021030112[-8] 2021123112[-8] Are you sure that GnuCash imported only December's transactions? Did you change the filter on the General Journal register or look in the account's register? Regards, John Ralls > On Jan 4, 2022, at 12:54 PM, Jesse MacDougall >

Re: [GNC] A good tutorial on connecting online to my bank accounts?

GnuCash cannot initiate transactions. You are limited to syncing previous transactions from the institution to GnuCash. Regards, Adrien On 1/4/22 2:27 PM, John Smith wrote: Is there a way to use GnuCash to connect to my credit union’s bank account and then move those funds from one account

Re: [GNC] A good tutorial on connecting online to my bank accounts?

You connect to your bank account and download those transactions into your Chart Of Accounts. "move those funds" - Are you talking about cash? or creating Adjusting Journal Entries? I haven't found any videos but I am on this process as well. Check for bank on here

[GNC] A good tutorial on connecting online to my bank accounts?

Is there a way to use GnuCash to connect to my credit union’s bank account and then move those funds from one account to another? Is there a good YouTube that explains this or a tutorial of some sort? Sent from my iPhone ___ gnucash-user mailing list

Re: [GNC] AqBanking Online Set Up

The import went smooth. Alot eaier then a .csv and other softwares I've used in my career. QFX is what I got but Royal Bank only included December transactions in the file when I chose the entire year. So this is great. Can download one file a month and post each transaction to proper account

Re: [GNC] AqBanking Online Set Up

You are right. I agree with you. I noticed this last night. On Tue, Jan 4, 2022 at 10:02 AM john wrote: > No, those are file download types, not connection options. Money means > OFX, Quicken probably means QFX but might mean QIF, QuickBooks probably > means QBO but might also mean QFX or QIF.

Re: [GNC] show unposted invoices in customer report?

On Tue, January 4, 2022 1:14 pm, Mattia Rizzolo wrote: > On Tue, Jan 04, 2022 at 12:46:33PM -0500, Derek Atkins wrote: >> The Customer Report is designed to be an "account status" for you to >> send >> to the Customer. Unposted Invoices effectively "do not exist" as far as >> the customer is

Re: [GNC] show unposted invoices in customer report?

On Tue, Jan 04, 2022 at 12:46:33PM -0500, Derek Atkins wrote: > The Customer Report is designed to be an "account status" for you to send > to the Customer. Unposted Invoices effectively "do not exist" as far as > the customer is concerned, so should not be in that report. Right, but what about

Re: [GNC] AqBanking Online Set Up

https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx At the end of the QFX import you were presented with a window listing all of the imported new transactions. Since

Re: [GNC] AqBanking Online Set Up

No, those are file download types, not connection options. Money means OFX, Quicken probably means QFX but might mean QIF, QuickBooks probably means QBO but might also mean QFX or QIF. I don't know what Makisoft is nor what file type Sage likes. GnuCash can handle the Money or Quicken

Re: [GNC] Closing Books - Pros & Cons

On 04 January 2022 at 17:17, Mattia Rizzolo said: > On Mon, Jan 03, 2022 at 08:39:26PM -0600, Adrien Monteleone wrote: > > You're welcome, and you did right by changing the subject. > > Unfortunately, replying to a digest doesn't thread to your original > > post. (as discussed in another thread)

Re: [GNC] show unposted invoices in customer report?

Hi, On Tue, January 4, 2022 12:38 pm, Mattia Rizzolo wrote: > Hi! > > I like that I'm able to draft an invoice and then keep it open until I'm > ready to post it. It makes trivial to me to take note in a place I'm > sure I won't forget (because I won't right?) of jobs I completed for a >

[GNC] show unposted invoices in customer report?

Hi! I like that I'm able to draft an invoice and then keep it open until I'm ready to post it. It makes trivial to me to take note in a place I'm sure I won't forget (because I won't right?) of jobs I completed for a customer, before it comes the time to invoice them for it. However, finding

Re: [GNC] A repository for user-contributed files

Hello David, Am 04.01.22 um 10:48 schrieb Dr. David Kirkby: > On Mon, 3 Jan 2022 at 22:08, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> But I >> guess if they are replying to the digest and they copy-paste the >> subject, as they should, then it will appear un-threaded. > >

Re: [GNC] GNUCash 4.9

What I did to correct my problem was to take the last backup file and remove all of the dates in the file name and made that my main (orginial) transaction file.  I opened that file as the data file and used it.  This corrected the issue with I was having. Thanks everyone for your responses.

Re: [GNC] Closing Books - Pros & Cons

On Mon, Jan 03, 2022 at 08:39:26PM -0600, Adrien Monteleone wrote: > You're welcome, and you did right by changing the subject. Unfortunately, > replying to a digest doesn't thread to your original post. (as discussed in > another thread) No way around that of which I am aware, but at least the >

Re: [GNC] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS

Jeff, If you are having difficulty Jeff you will have to tell us exactly what you have done and which commands you have entered into the terminal and exactly what the terminal output is to each command. We are not mind readers and we are not on your system so unless you tell us we do not know

Re: [GNC] Closing Books - Pros & Cons

On 03 January 2022 at 18:34, Ryan Carver said: [...] > PS - Am I correctly replying to the List Serve in regards to "editing the > subject line" and "replying all" so the thread is documented correctly? As > mentioned, I am knew to all this. You are replying to a plaintext Digest. Threading only

Re: [GNC] A repository for user-contributed files

On Tue, 4 Jan 2022 09:48:52 + "Dr. David Kirkby" wrote: > I think there’s a good argument for either > a) Stopping the digest mode OR > b) Insisting that if people want to reply to something that they see > in the digest, they reply to the archive - assuming that maintains > the thread. > >

Re: [GNC] A repository for user-contributed files

On Mon, 3 Jan 2022 at 22:08, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > But I > guess if they are replying to the digest and they copy-paste the > subject, as they should, then it will appear un-threaded. I think there’s a good argument for either a) Stopping the digest mode

Re: [GNC] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS

*Caveat, I haven't tried building 4.9 yet, or used the referenced script, but the below should still apply generally: You're not dealing with a PPA. The script is getting the source from Github and then building. A PPA contains already built packages. The wiki shows how to get info from the