Re: [GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

For transfers, I put both dates in the description, and start it at the from date for ease of reconciling that account, then move it to the to date for ease in reconciling that account.  I have not tried that for checks, but might start them when cleared and then move them to when written. 

Re: [GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

On Sat, Jun 1, 2024 at 3:40 PM David G. Pickett via gnucash-user < gnucash-user@gnucash.org> wrote: > I like to record my checks written on the day they were written, not > cashed, but am frustrated that then I cannot check when they cleared! > Float is nice, especially if you get interest, but

Re: [GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

On 6/1/2024 4:39 PM, David G. Pickett via gnucash-user wrote: I like to record my checks written on the day they were written, not cashed, but am frustrated that then I cannot check when they cleared! Well technically should be recorded when delivered, with delivered meaning "constructively

Re: [GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

David, AFAIK the reconcile "R" column has three settings ,"n","c","y". If you manually record a transaction it should be set at "n". The "c" setting indicates that a transaction has been cleared and can be set to this when for example the money either appears in your account or when it has been

Re: [GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

I like to record my checks written on the day they were written, not cashed, but am frustrated that then I cannot check when they cleared!  Float is nice, especially if you get interest, but not something I bank on!  :D  Similarly, one bank puts a 3 day hold on transfers, so the money goes out

Re: [GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

Bruce. There should be no problem just adding additional lines for each sale and shipping label purchase and fee transaction to the single transaction with the debit entry to your check account being the payout figure.  Alternatively if you have the gross amount of each sale available you can

Re: [GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

Bruce: Welcome to GnuCash, congratulations on the eBay business, and I hope it goes well for you. It sounds like your question is not about GnuCash, it is about accounting. Once you know how the information should get tracked as an accounting matter, it will be straightforward to explain

[GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later

I’m looking for help in figuring out GnuCash for a small eBay reseller, basically selling items from home, but occasionally purchasing an item for resale. I’m looking at this from the perspective of viewing sales from the My eBay / Selling / Payments / Total Sales page. Under Assets, I have

Re: [GNC] need help getting started

Eric, On the gnucash.org homepage you must have missed the "Development" panel - first item - "How to help" points to https://wiki.gnucash.org/wiki/Contributing_to_GnuCash which covers how to help with development - scroll down to "Coders" section. Further links in it re coding standards, yada,

Re: [GNC] need help getting started

Eric, Check the Help and the Tutorial (linked from the website, but should be available from within GnuCash). I don't recall which, but one describes the CSV format for importing bills/invoices. I don't *think* you can import them as paid, because it isn't just a flag on the transaction.

[GNC] need help getting started

To the group, A short intro: I have been a user of Quicken for the last 1000 years or so, they have gone from a business that cares about customers to not so much. Late last year one of their updates lost or scrambled years of my business accounting data, and my backups. Their help line

Re: [GNC] Need help importing Investment transactions

David, The issues with building GC4.9 on Ubuntu 20.04 are likely relatively minor as far as I can see, and mainly those that first time builders of GnuCash encounter with getting the dpendencies and build environment setup and enough familiarity with the process to be able to avoid the common

Re: [GNC] Need help importing Investment transactions

I almost forgot that there is an issue with release 3.8 where scheduled reinvested dividend transactions and other stock purchase transactions do not correctly apply the share price when the SX runs which I know has been fixed in the 4.something update. Maybe that fix also fixed this issue? On

Re: [GNC] Need help importing Investment transactions

The main difference is that I am using release 3.8. At the matching step after I touch add so it won't erase the text in the existing transactions it declares that the four non-zero value dividend transactions are already balanced and it won't let me assign an income account. Then I touch Next

Re: [GNC] Need help importing Investment transactions

Your example worked fine for me in GnuCash 4.9. I set it to ignore the first 5 rows, set the date field to Date, the description field to Description, and the Amount Field to deposit and ignored the rest. I used Assets:Investment:Brokerage Account for the target account. On import the matcher

Re: [GNC] Need help importing Investment transactions

I have created a test csv import file and I can replicate the single line out-of-balance imported transactions. . Reminder, I am still using release 3.8 in Llnux Lite [Ubuntu 20.04]. The test file is pure text, I will quote it to be sure that it gets through. Alas, that adds spurious carriage

Re: [GNC] Need help importing Investment transactions

It will be a while before I can find an adequate time window to test and post an example csv with instructions to duplicate the single line transactions that I saw the other day. I still have the csv file and the import configuration so I should be able to do it. In the meantime have a nice

Re: [GNC] Need help importing Investment transactions

> On Dec 22, 2021, at 8:58 PM, David Carlson > wrote: > > I am currently running release 3.8 in Linux Lite, which is Ubuntu 20.04 > under a different label. I think that the CSV transaction import has not > been changed, between 3.8 and 4.9. If that is not correct, then some of my > issues

[GNC] Need help importing Investment transactions

I am currently running release 3.8 in Linux Lite, which is Ubuntu 20.04 under a different label. I think that the CSV transaction import has not been changed, between 3.8 and 4.9. If that is not correct, then some of my issues may be bugs that have been fixed. I have read the current help

Re: [GNC] Need help

Hello Glen, As a note of encouragement, I also read it when I first started after bumping my head into things which now seem obvious. The authors did a very nice job making it easily readable and walking you through step by step. It doesn't answer every question, but it gives you the foundation

Re: [GNC] Need help

Glen, Welcome! Because it is so easy to make practice files and more practice files and delete and start over, you do not need to read the entire 311 pages before you start! Also, the only test is the one where you get a result that meets your needs. On Fri, Apr 16, 2021 at 6:05 AM Liz wrote:

Re: [GNC] Need help

On Fri, 16 Apr 2021 12:54:33 +0200 "Glen Bailie" wrote: > Dear Sirs, > > I am trying to set up a set of books, but have come across some > problems for which I need help. > > !) How do I get into Accounts, > > 2) How do I do transactions from a bank cheque account, such as > receipts and

[GNC] Need help

Dear Sirs, I am trying to set up a set of books, but have come across some problems for which I need help. !) How do I get into Accounts, 2) How do I do transactions from a bank cheque account, such as receipts and payments that are not from customers or vendors. For example bank charges, and

Re: [GNC] Need help correcting transaction account [RESOLVED]

On Mon, 1 Mar 2021, Adrien Monteleone wrote: The context menu (right click) should give you the option to open the invoice. The should work for either the invoice transaction or linked payment transaction. Adrien, That right click did the trick; it never occurred to me to try that on

Re: [GNC] Need help correcting transaction account

The invoice # is supposed to appear in the NUM/Action column. (Also, an "I" appears to the right of the date for invoices/bills, and for payments it is a "P") The context menu (right click) should give you the option to open the invoice. The should work for either the invoice transaction or

Re: [GNC] Need help correcting transaction account

On Mon, 1 Mar 2021, Derek Atkins wrote: Jump over to the AR/AP account for the transaction and there it should have the Invoice # in the register. derek, Ah! I overlooked that account. I see it in the A/P register but there's no invoice number in any of the columns. I don't suppose I can

Re: [GNC] Need help correcting transaction account

HI, Jump over to the AR/AP account for the transaction and there it should have the Invoice # in the register. -derek On Mon, March 1, 2021 12:21 pm, Rich Shepard wrote: > ast October 24th I mis-posted an SBA-PPP loan salary payment as a debit to > the loan liability account rather than to the

[GNC] Need help correcting transaction account

ast October 24th I mis-posted an SBA-PPP loan salary payment as a debit to the loan liability account rather than to the members draw expense account. I cannot delete that transaction and re-enter it because gnucash tells me it was paid on an invoice, and I cannot find that invoice searching for

Re: [GNC] Need help using Gnucash IRC to live chat

Derek is right. Wiki IRC to find a list. On Sat, Dec 5, 2020, 10:45 AM Derek Atkins wrote: > There are tons of free IRC clients. > -derek > > On Sat, December 5, 2020 11:22 am, Fran_3 via gnucash-user wrote: > > 1 - Must I buy mIRC to get to the Gnucash IRC server and channel?2 - Are > > their

Re: [GNC] Need help using Gnucash IRC to live chat

There are tons of free IRC clients. -derek On Sat, December 5, 2020 11:22 am, Fran_3 via gnucash-user wrote: > 1 - Must I buy mIRC to get to the Gnucash IRC server and channel?2 - Are > their any free open source alternatives to mIRC?Thanks for any help. > >

[GNC] Need help using Gnucash IRC to live chat

1 - Must I buy mIRC to get to the Gnucash IRC server and channel?2 - Are their any free open source alternatives to mIRC?Thanks for any help. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to

Re: [GNC] Need help related to mortgages

Anthony This forum is not for advice on financial matters per se but only on how to use the Gnucash accounting program to record financial events. You need to consult your financial adviser or an accountant for the advice you are seeking. David Cousens - David Cousens -- Sent from:

[GNC] Need help related to mortgages

I am planning to buy my first house in the near future. Have a few questions about the buying process. From my understanding, the pre-approval rate that you get may not be the same as the rate you get when you are actually approved. You may receive a lower rate once your offer on a house is

Re: [GNC] Need help reconciling

Hi, ToddAndMargo via gnucash-user writes: > okay, I am just not understanding. > > In the reconcile window > > 1) I presume "Statement Date" is my statement's closing >date? Correct. > 1) the statement date matches my bank statement Good. > 2) starting balance is 0 (it is not) I assume

Re: [GNC] Need help reconciling

Todd The Statement date is the closing date on your statement. If the statement date does not match then you set it to the closing date on your statement. I have never changed the reconcile status to c or anything else (unless I needed to manually unreconcile a statement period which I don't

Re: [GNC] Need help reconciling

You have to fix the starting balance first. If this is your first reconcile of a pre-existing account, read the docs as this is a little different. More than likely, you can just reconcile starting from zero and include your Opening Balance transaction which should get you to the proper ending

Re: [GNC] Need help reconciling

On 4/26/19 3:19 PM, ToddAndMargo via gnucash-user wrote: Hi All, I have been looking over the "Reconcile" on on eof m yu credit card account.  I just don understand what I am seeing. 1) do I put a "c" in the opening balance as I I has checked it? 2) I have put "C" in all the charges on my

Re: [GNC] Need help reconciling

On 4/27/19 2:29 AM, Liz wrote: We all learn in different combinations of three main ways Hearing, Doing and Seeing It doesn't matter how. Most importantly Some people just don't learn from lectures some just don't learn from reading a book some only learn by doing and asking questions.

Re: [GNC] Need help reconciling

On 4/27/19 3:18 AM, Michael Hendry wrote: On 27 Apr 2019, at 10:29, Liz wrote: On Sat, 27 Apr 2019 14:16:25 +0530 "David T. via gnucash-user" wrote: ToddAndMango, you might try reading the documentation. I'm going to put my education hat on here We all learn in different combinations

Re: [GNC] Need help reconciling

On 4/27/19 2:29 AM, Liz wrote: For the human identified as ToddAndMargo Can't think of a way to remove the private information ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Need help reconciling

> On 27 Apr 2019, at 10:29, Liz wrote: > > On Sat, 27 Apr 2019 14:16:25 +0530 > "David T. via gnucash-user" wrote: > >> ToddAndMango, you might try reading the documentation. > > I'm going to put my education hat on here > > We all learn in different combinations of three main ways >

Re: [GNC] Need help reconciling

On Sat, 27 Apr 2019 14:16:25 +0530 "David T. via gnucash-user" wrote: > ToddAndMango, you might try reading the documentation. I'm going to put my education hat on here We all learn in different combinations of three main ways Hearing, Doing and Seeing It doesn't matter how. Most

Re: [GNC] Need help reconciling

All of this is covered in the Guide at https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_txns.html#txns-reconcile1 , especially 2.9.4.1, which includes a section regarding the starting balance, as well as

Re: [GNC] Need help reconciling

On Sat, 27 Apr 2019 at 08:48, Colin Law wrote: > > On Sat, 27 Apr 2019 at 08:34, ToddAndMargo via gnucash-user > wrote: > > > > On 4/27/19 12:11 AM, Colin Law wrote: > > > I am sure we have been over this before. You should not generally > > > need to touch the reconcile column in the register

Re: [GNC] Need help reconciling

On Sat, 27 Apr 2019 at 08:34, ToddAndMargo via gnucash-user wrote: > > On 4/27/19 12:11 AM, Colin Law wrote: > > I am sure we have been over this before. You should not generally > > need to touch the reconcile column in the register yourself. It is > > all done through the Reconcile feature.

Re: [GNC] Need help reconciling

On 4/27/19 12:11 AM, Colin Law wrote: I am sure we have been over this before. You should not generally need to touch the reconcile column in the register yourself. It is all done through the Reconcile feature. Open the credit card (or bank) account and select Options > Reconcile. Check the

Re: [GNC] Need help reconciling

I am sure we have been over this before. You should not generally need to touch the reconcile column in the register yourself. It is all done through the Reconcile feature. Open the credit card (or bank) account and select Options > Reconcile. Check the opening balance matches the opening

Re: [GNC] Need help reconciling

On 4/26/19 10:13 PM, Liz wrote: On Fri, 26 Apr 2019 19:59:32 -0500 (CDT) David Cousens wrote: Me: Where's the ? Wife: In the refrigerator. Me: No it isn't. Wife: Yes it is. Me: Definitely is not! Wife: Walks to refrigerator, opens the door grab.s . from the front of the middle

Re: [GNC] Need help reconciling

On Fri, 26 Apr 2019 19:59:32 -0500 (CDT) David Cousens wrote: > Me: Where's the ? > Wife: In the refrigerator. > Me: No it isn't. > Wife: Yes it is. > Me: Definitely is not! > Wife: Walks to refrigerator, opens the door grab.s . from the > front of the middle shelf. > Wife Dirty look.

Re: [GNC] Need help reconciling

On Fri, Apr 26, 2019 at 6:44 PM ToddAndMargo via gnucash-user < gnucash-user@gnucash.org> wrote: > On 4/26/19 4:36 PM, Tommy Trussell wrote: > > Most of the time you probably don't want to bother with the n or c flags > > in the ledger -- let GnuCash do that for you, through the > > I think the

Re: [GNC] Need help reconciling

On 4/26/19 5:59 PM, David Cousens wrote: Me: Where's the ? Wife: In the refrigerator. Me: No it isn't. Wife: Yes it is. Me: Definitely is not! Wife: Walks to refrigerator, opens the door grab.s . from the front of the middle shelf. Wife Dirty look. That could be my house!

Re: [GNC] Need help reconciling

Sounds like me at the grocery store. Just tell me what aisle, even better something big beside it, and like magic it appears, even though I'd already checked that area thoroughly. On Fri, 26 Apr 2019 at 20:35, David Cousens wrote: > Todd, > > >Why I could not find it on my own, I can only

Re: [GNC] Need help reconciling

Todd, >Why I could not find it on my own, I can only speculate ... We all went through not being able to find stuff at one point. Sometimes the greatest help is just knowing it exists somewhere. David - David Cousens -- Sent from:

Re: [GNC] Need help reconciling

On 4/26/19 4:55 PM, David Cousens wrote: Todd, Google "GnuCash" and a keyword or phrase and google will usually locate specific info within the documentation on a topic. Doesn't always work but usually gets you into the ballpark. Google "GnuCash reconcile" lists the relevant help manual

Re: [GNC] Need help reconciling

On 4/26/19 4:57 PM, David Carlson wrote: If you are using GMail Zoho mail ___ 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

Re: [GNC] Need help reconciling

ToddAndMargo, If you are using GMail, it tries to hide what it considers less important, which often accidentally hides important information. Click on the three dots icon to see the rest. David Carlson On Fri, Apr 26, 2019 at 6:43 PM ToddAndMargo via gnucash-user < gnucash-user@gnucash.org>

Re: [GNC] Need help reconciling

Todd, Google "GnuCash" and a keyword or phrase and google will usually locate specific info within the documentation on a topic. Doesn't always work but usually gets you into the ballpark. Google "GnuCash reconcile" lists the relevant help manual entry as well as the tutorial and concepts

Re: [GNC] Need help reconciling

Hi! Welcome to GnuCash! On Fri, Apr 26, 2019 at 5:22 PM ToddAndMargo via gnucash-user < gnucash-user@gnucash.org> wrote: > I have been looking over the "Reconcile" on on eof m yu > credit card account. I just don understand what I am seeing. > > 1) do I put a "c" in the opening balance as I > I

[GNC] Need help reconciling

Hi All, I have been looking over the "Reconcile" on on eof m yu credit card account. I just don understand what I am seeing. 1) do I put a "c" in the opening balance as I I has checked it? 2) I have put "C" in all the charges on my bank statement. 3) I press the Reconcile button and I put in

Re: [GNC] Need help with a Savings account

On 17 April 2019 at 19:12, ToddAndMargo said: > On 4/16/19 1:24 AM, Fred Bone wrote: > >> So I should switch my opening balance to a negative number? > > > Possibly. It rather depends on whether your account was overdrawn when > > you started your current books. > > My paper bank book and bank

Re: [GNC] Need help with a Savings account

David, I agree, a reading of the Guide would have helped significantly. Perhaps I should have refrained from personal assistance and commentary and simply pointed to the relevant sections. That is likely the better approach, especially since the ‘work’ in explaining is already done. Regards,

Re: [GNC] Need help with a Savings account

> On Apr 17, 2019, at 11:18 PM, AC wrote: > > On 2019-04-17 20:00, Adrien Monteleone wrote: >> And I also agree that the GnuCash defaults of informal labels and Basic View >> are much simpler to comprehend. >> >> However, once someone encounters a situation where they don’t understand >>

Re: [GNC] Need help with a Savings account

Adrien, The Guide covers in some detail both the concept of double entry and debits and credits. In fact, some have suggested that the guide goes into too much detail about these concepts.  It was the reason I suggested that the recent user consult the documentation, since it explained

Re: [GNC] Need help with a Savings account

On 2019-04-17 20:00, Adrien Monteleone wrote: > And I also agree that the GnuCash defaults of informal labels and Basic View > are much simpler to comprehend. > > However, once someone encounters a situation where they don’t understand > ’transfer’ account or the nature of double-entry,

Re: [GNC] Need help with a Savings account

Colin, I agree, most people are coming from a place of hearing those terms from the institution’s perspective, which confuses many at first. And I also agree that the GnuCash defaults of informal labels and Basic View are much simpler to comprehend. However, once someone encounters a

Re: [GNC] Need help with a Savings account

On 4/16/19 9:32 AM, Colin Law wrote: It may have been mentioned before but in Settings > Accounts there is a checkbox, Use formal accounting labels. If you clear that then the headings on bank accounts say withdrawal and deposit, and on Credit card accounts say Charge and Payment, which I find

Re: [GNC] Need help with a Savings account

“Debt” and “Debit” are NOT the same thing, despite they are 1 letter apart. If the balance of your bank account is positive (you have money to spend in it) then your opening balance entry in GnuCash should be a debit to that account and a credit to `Equity:Opening Balances`. That isn’t because

Re: [GNC] Need help with a Savings account

On 4/16/19 5:41 AM, Michael or Penny Novack wrote: On 4/15/2019 6:11 PM, ToddAndMargo via gnucash-user wrote: Hi All, Now that I am feeling brave coming off of creating a charge card account, I decided to create a saving account. My bank statement shows deposits as positive numbers and

Re: [GNC] Need help with a Savings account

On 4/16/19 1:24 AM, Fred Bone wrote: So I should switch my opening balance to a negative number? Possibly. It rather depends on whether your account was overdrawn when you started your current books. My paper bank book and bank statement shows a positive number. They way I am understanding

Re: [GNC] Need help with a Savings account

On Tue, 16 Apr 2019 at 01:14, John Clark via gnucash-user wrote: > > Because these terms ‘never make sense’, as seen by this example. It is far > more simpler to just say, money coming in, on the left, money going out on > the right… or is the other way around... Money moves from right to

Re: [GNC] Need help with a Savings account

On 4/15/2019 6:11 PM, ToddAndMargo via gnucash-user wrote: Hi All, Now that I am feeling brave coming off of creating a charge card account, I decided to create a saving account. My bank statement shows deposits as positive numbers and withdrawals as negative numbers, so I decided to follow

Re: [GNC] Need help with a Savings account

On 15 April 2019 at 15:43, ToddAndMargo said: [...] > So, when I deposit something to the bank, I am actually > losing money (giving it to someone else), so it is a debit? No, you are handing it to them, so they owe it back. That's what "debit" means, after all. > So I should switch my opening

Re: [GNC] Need help with a Savings account

Sorry, too much copying and pasting and not enough proofreading. That second ‘report’ should have read: === ToddAndMargo Balance Sheet (partial) as of April 15, 2019 Assets Cash$ 250 Savings $ 900 - Total Assets$1150

Re: [GNC] Need help with a Savings account

As Dale mentioned in another reply, money moves from credit to debit. Do not think of the money as moving from you to the bank. Think of the money as moving from one (or more) of your accounts to another one (or more) of your accounts. Everything is done within and from the perspective of

Re: [GNC] Need help with a Savings account

> On Apr 15, 2019, at 4:10 PM, Adrien Monteleone > wrote: > > I wrote a longer reply, but let’s get this out of the way first: > > What makes you think ‘losing money’ = ‘debit’? Because these terms ‘never make sense’, as seen by this example. It is far more simpler to just say, money coming

Re: [GNC] Need help with a Savings account

On 4/15/19 4:10 PM, Adrien Monteleone wrote: What makes you think ‘losing money’ = ‘debit'? Hi Adrian, By "losing money", I meant money moving away from me. From me (debit) to the bank By the way, I am a bit disturbed with myself that I actually understood your reply. By chance do you have

Re: [GNC] Need help with a Savings account

I wrote a longer reply, but let’s get this out of the way first: What makes you think ‘losing money’ = ‘debit'? Regards, Adrien > > Hi Adrian, > > So, when I deposit something to the bank, I am actually > losing money (giving it to someone else), so it is a debit? > > So I should switch my

Re: [GNC] Need help with a Savings account

>> On Apr 15, 2019, at 5:11 PM, ToddAndMargo via gnucash-user wrote: >> >> Hi All, >> >> Now that I am feeling brave coming off of creating a charge >> card account, I decided to create a saving account. >> >> My bank statement shows deposits as positive numbers and >> withdrawals as negative

Re: [GNC] Need help with a Savings account

A simple rule for getting the debit and credit correct is money flows from credit to debit. So if you want to remove $10 from the savings account that will be a credit of $10 to savings and debit of $10 to some other account(s) such as Expense. Dale On 4/15/19 5:11 PM, ToddAndMargo via

Re: [GNC] Need help with a Savings account

Another reminder - the Bank’s use of “debit/credit” with respect to your account is with respect to your account in *their* books which lies on the opposite of the ledger/accounting equation from *your* books. So when they ‘debit your account’ to decrease it, that is because *to them* your

Re: [GNC] Need help with a Savings account

No, debiting an asset account means you increased it. A withdrawal would be a credit to an asset account. Remember: Assets + Expenses = Liabilities + Equity + Income Left side of “=“ means ‘debit increases/credit decreases’ The opposite for the right side of the “=“ Regards, Adrien > On Apr

[GNC] Need help with a Savings account

Hi All, Now that I am feeling brave coming off of creating a charge card account, I decided to create a saving account. My bank statement shows deposits as positive numbers and withdrawals as negative numbers, so I decided to follow suite Okay, I set the initial test balance to +100. It shows

[GNC] Need help setting up OFX. Getting Signer not found on 2 different banking entities? Do I need a certificate?

Hi all, I see this issue from GNUCash. The same accounts are downloading fine on Quicken 2017. Both fidelity and vanguard returned the same error. It appears there's something wrong in my setup. Is there a missing certificate I need to get? AqBanking v5.7.8.0stable Sending jobs to the bank(s)