[GNC] Follow up on Gnucash invoicing and payment - questions on process
Following my previous email on the subject, thank you to members and to the four friends who responded. Feedback and additional question below. It took me a while to understand what you were saying, but with your indication of liabilities, that got me thinking and I did manage to find the solution. - Create liabilities accounts for each donor under Liabilities, - $ is credited to the bank account and to the donors Receipt account, - $ are debited from the donors Receipt account to the donor's newly created liability account - Invoices are paid by inserting the payment in the PAY on the posted invoice and debiting the liability account. It all squares. Thank you Now if you guys can tell me how to produce a report (spreadsheet like) which shows all customers invoices in column A with the name of the customer and the invoices , amount invoiced per invoice in column B, amount paid per invoice in column C, and balance due per invoice in column D, you will have made my day!!! *Charles Vincent* Trésorier et ancien président du Conseil d'Administration EFB - Ecole *Française* de Battambang www.ecolefrancaisedebattambang.org Tel: +33 6 7082 0475 +855 12 635612 (Telegram) On Thu, Oct 6, 2022 at 8:59 PM Charles Vincent < memb...@ecolefrancaisedebattambang.org> wrote: > Hello Gnucash users list members, > I come back on the issue of invoicing clients and payment by the clients > or a third party. > > As background: > For info, I am keeping the accounts for a small not for profit school in > Cambodia. > I have done the 70 invoices, one for each child, using a standard > accounting layout: R1 income school fees, R2 income registration, R3 income > extracurricular, etc etc.. > So far so good. > I post the invoices, still good. > The invoices show up in an accounts receivable STUDENT INVOICES as I > believe they should. If so, so far so very good. > > The problem comes up with the management of the accounts when I receive > funds > I have two cases which are giving me problems related to the income that > we receive for which I am consulting this group: > > Case 1: The parents have anticipated some expenses from trimester 2 and 3 > and hence have paid more than the posted invoice. Let us say the invoice is > for USD 2,000 and the payment received in the bank is USD 2,500. > When I use the payment option, I do not see the 500 extra payment when I > print the invoice (which I would consider by this time as a Statement of > Account) > Advice appreciated on how to enter the amount and that the printed invoice > shows the overpayment. > > Case 2: We received in the bank a donation of say USD 8,000 on say 1 > September from a donor for a scholarship fund for 4 students. I have > therefore credited the bank account on 1 Septemberr for 8,000$ and credited > the income account of the donor (let's call it R7) for the amount of > $8,000. > The issue becomes how I credit the 4 invoices which are dated 15 September > for the students as the funds are a. in the bank, b. credited to the income > account R7. I could not "pay" the invoice from the R7 account (not > possible in the Gnucash setup it seems) so that the various amounts flow to > the various Rs, R1, R2, R3,... . as per the invoice set up. From my > perspective it is more of a Journal Voucher type transaction, moving funds > from R7 to R1, R2, R3,... so that the proper amounts are credited to the > proper income accounts, reducing the amount under R7, i.e. allocating the > donors funds to various activities. > I tried various ways but the PAY option in the invoice does not work. Any > suggestions? > > Thank you > > > *Charles Vincent* > > Trésorier et ancien président du Conseil d'Administration > > EFB - Ecole *Française* de Battambang > > www.ecolefrancaisedebattambang.org > > > Tel: +33 6 7082 0475 > > +855 12 635612 (Telegram) > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Gnucash invoicing and payment - questions on process
Hello Gnucash users list members, I come back on the issue of invoicing clients and payment by the clients or a third party. As background: For info, I am keeping the accounts for a small not for profit school in Cambodia. I have done the 70 invoices, one for each child, using a standard accounting layout: R1 income school fees, R2 income registration, R3 income extracurricular, etc etc.. So far so good. I post the invoices, still good. The invoices show up in an accounts receivable STUDENT INVOICES as I believe they should. If so, so far so very good. The problem comes up with the management of the accounts when I receive funds I have two cases which are giving me problems related to the income that we receive for which I am consulting this group: Case 1: The parents have anticipated some expenses from trimester 2 and 3 and hence have paid more than the posted invoice. Let us say the invoice is for USD 2,000 and the payment received in the bank is USD 2,500. When I use the payment option, I do not see the 500 extra payment when I print the invoice (which I would consider by this time as a Statement of Account) Advice appreciated on how to enter the amount and that the printed invoice shows the overpayment. Case 2: We received in the bank a donation of say USD 8,000 on say 1 September from a donor for a scholarship fund for 4 students. I have therefore credited the bank account on 1 Septemberr for 8,000$ and credited the income account of the donor (let's call it R7) for the amount of $8,000. The issue becomes how I credit the 4 invoices which are dated 15 September for the students as the funds are a. in the bank, b. credited to the income account R7. I could not "pay" the invoice from the R7 account (not possible in the Gnucash setup it seems) so that the various amounts flow to the various Rs, R1, R2, R3,... . as per the invoice set up. From my perspective it is more of a Journal Voucher type transaction, moving funds from R7 to R1, R2, R3,... so that the proper amounts are credited to the proper income accounts, reducing the amount under R7, i.e. allocating the donors funds to various activities. I tried various ways but the PAY option in the invoice does not work. Any suggestions? Thank you *Charles Vincent* Trésorier et ancien président du Conseil d'Administration EFB - Ecole *Française* de Battambang www.ecolefrancaisedebattambang.org Tel: +33 6 7082 0475 +855 12 635612 (Telegram) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Questions on invoicing and invoice format
Adrien, Thank you VERY much for your replies. I will definitely be less frustrated not being able to figure something out which cannot be done (at this stage). Good suggestion for q. no. 1. Again, thanks. Charles VINCENT Membre fondateur et ancien président du Conseil d'Administration Ecole Française de Battambang +33 6 7082 0475 (Mobile & WhattsApp) +855 12 635612 (Telegram) www.ecolefrancaisedebattambang.org On Wed, Jun 22, 2022, 20:34 Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > On 6/22/22 4:40 AM, Charles Vincent wrote: > > 1. Is it possible to delete invoices? As I was setting up invoices, I > made > > some mistakes so I now have invoice 1, invoice 2 and invoice 3 with > > different print options for the same student but I cannot seem to find a > > way to delete unnecessary invoices. Any option for that? > > No, you can't delete them. > > But you can re-assign them to someone else. > > When this happens, I usually edit the invoice# to be something like 'Use > Next' and before starting an invoice, I'll do a Find for the 'Use Next' > invoice#, then edit from there. > > > 2. How do I save a Fancy invoice configuration which will apply to all > > clients? Right now, the only way I have been able to do it is to save > the > > fancy configuration for client 1 but when I use the same configuration > for > > client 2, it comes out with the name of client 1 instead of client 2. > > What I am asking is the process to save a Print Invoice configuration > (or a > > Report /Saved Report configurations) which can be used for many clients > > without having to format each individual client. > > As far as I know, there is no way to specify a different default > configuration. It would be a very useful enhancement. Unless you really > need to, I'd avoid putting client info in the configuration. Keep it as > general as possible. > > > > 3. What is the process to ensure that When I open and insert amounts in > a > > new invoice, what is the process to ensure that it automatically goes to > > the right print invoice fancy format? I cannot figure it out. > > It doesn't work automatically. You have to choose the stylesheet each > time if you want to use one other than the default. (note, you *can* > edit and save changes to the default) There is no way to change *which* > stylesheet is the default. This too would be quite useful. > > > 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.
[GNC] Questions on invoicing and invoice format
I have launched myself into trying to set up an invoicing capacity for our non profit school association's 70 students (clients). I am running into a few issues for which I will be most grateful for advice and guidance. Let me start with these 3 Key questions, I will follow up with others I have no doubt. 1. Is it possible to delete invoices? As I was setting up invoices, I made some mistakes so I now have invoice 1, invoice 2 and invoice 3 with different print options for the same student but I cannot seem to find a way to delete unnecessary invoices. Any option for that? 2. How do I save a Fancy invoice configuration which will apply to all clients? Right now, the only way I have been able to do it is to save the fancy configuration for client 1 but when I use the same configuration for client 2, it comes out with the name of client 1 instead of client 2. What I am asking is the process to save a Print Invoice configuration (or a Report /Saved Report configurations) which can be used for many clients without having to format each individual client. 3. What is the process to ensure that When I open and insert amounts in a new invoice, what is the process to ensure that it automatically goes to the right print invoice fancy format? I cannot figure it out. As background, a. I have set up a new invoice for student no. 1 . That is fine b. I have set up a print invoicefancy look configuration for that client. That is fine also. But it is unclear how to proceed to have a configuration which will automatically apply to all invoices Thanks for the guidance *Charles Vincent* Trésorier et ancien président du Conseil d'Administration EFB - Ecole *Française* de Battambang www.ecolefrancaisedebattambang.org Tel: +33 6 7082 0475 +855 12 635612 (Telegram) ___ 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] Question on opening files
Thank you to colleagues. Problem resolved. I am not quite sure what I did but the concerned file is opening and not minimizing. Have a great 2022! *Charles * On Thu, Dec 30, 2021 at 5:42 PM Gyle McCollam wrote: > He was referring to the Windows 10/11 icon. If you right-click on the > gnucash icon, you should see 3 options: Gnucash, unpin from taskbar, and > close all windows. Then, if you right-click on the Gnucash, the last > option should be "properties". Left Click properties. In the Gnucash > properties near the bottom is a run option. The three selections are: > "Normal Window, Minimized, Maximized". It probably has minimized > selected as the option. > > Thank You, > *Gyle McCollam* > > Gyle McCollam > > 609.680.2326 Mobile > > gmccol...@live.com email > -- > *From:* Charles Vincent > *Sent:* Thursday, December 30, 2021 11:16 AM > *To:* Glenn Fowler > *Cc:* Gyle McCollam ; gnucash-user@gnucash.org < > gnucash-user@gnucash.org> > *Subject:* Re: [GNC] Question on opening files > > Thanks. > Some files open without problems but some do not. > Which properties are you referring to? In gnucash or generally ? > > Charles VINCENT > Membre fondateur et ancien président du Conseil d'Administration > > Ecole Française de Battambang > > +33 6 7082 0475 (Mobile & WhattsApp) > +855 12 635612 (Telegram) > > www.ecolefrancaisedebattambang.org > > On Tue, Dec 28, 2021, 16:36 Glenn Fowler wrote: > > Are you possibility opening from a desktop shortcut? If so, right click > > Properties and make sure Minimized is not selected in "Run" as shows in the > attached screenshot. > > > On Tue, Dec 28, 2021 at 10:30 AM Charles Vincent < > memb...@ecolefrancaisedebattambang.org> wrote: > > Repeating copying... > > Windows10. I just opened up a file just sent to me without problems. It > appears to affect older files, ( the one I need was saved in March 2021). > > > *Charles * > > > > > On Tue, Dec 28, 2021 at 4:24 PM Gyle McCollam wrote: > > > Charles, Question, what operating system are you using? > > > > Thank You, > > *Gyle McCollam* > > > > Gyle McCollam > > > > 609.680.2326 Mobile > > > > gmccol...@live.comemail > > -- > > *From:* gnucash-user > > on behalf of Charles Vincent > > *Sent:* Tuesday, December 28, 2021 10:17 AM > > *To:* gnucash-user@gnucash.org > > *Subject:* [GNC] Question on opening files > > > > For the last few weeks, i have noticed that some gnucash files which I > had > > saved open but are minimized and cannot be restored maximized. Anyone > else > > encountering this issue and any suggestions? > > Thank you > > > > > > *Charles * > > ___ > > 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. > > ___ 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] Question on opening files
Repeating copying... Windows10. I just opened up a file just sent to me without problems. It appears to affect older files, ( the one I need was saved in March 2021). *Charles * On Tue, Dec 28, 2021 at 4:24 PM Gyle McCollam wrote: > Charles, Question, what operating system are you using? > > Thank You, > *Gyle McCollam* > > Gyle McCollam > > 609.680.2326 Mobile > > gmccol...@live.comemail > -- > *From:* gnucash-user > on behalf of Charles Vincent > *Sent:* Tuesday, December 28, 2021 10:17 AM > *To:* gnucash-user@gnucash.org > *Subject:* [GNC] Question on opening files > > For the last few weeks, i have noticed that some gnucash files which I had > saved open but are minimized and cannot be restored maximized. Anyone else > encountering this issue and any suggestions? > Thank you > > > *Charles * > ___ > 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.
[GNC] Question on opening files
For the last few weeks, i have noticed that some gnucash files which I had saved open but are minimized and cannot be restored maximized. Anyone else encountering this issue and any suggestions? Thank you *Charles * ___ 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.
