Applying Customer overpayments

2018-02-08 Thread Alan Johnson
Hello, I'm having an issue with GnuCash. A customer has a overpayment/credit balance. How do I apply it to an invoice so that it comes out of the AR report at the bottom of the customer report? The total due / sums are correct, but the customer report has a 91+ day balance of (0.03). I would li

Re: Applying Customer overpayments

2018-02-08 Thread Alan Johnson
merely states that GnuCash would keep track of any overpayment. It sounds like a feature like QuickBoox payment system check box "Apply customer balance to invoice" is needed. Alan On 2/8/2018 1:09 PM, Geert Janssens wrote: Op donderdag 8 februari 2018 18:41:56 CET schreef Alan Joh

[GNC] Problem upgrading to GunCash 3.0

2018-04-11 Thread Alan Johnson
Hello, I recently installed GNUCash 3.0 from 2.8. I have several accounting files. One of them does not load / crashes on load with the trace error: * 16:36:05  WARN Could not spawn perl: Failed to execute child process (No such file or directory) * 16:36:27  WARN error reading group Page 1

[GNC] Issue with default invoice template

2023-10-03 Thread Alan Johnson via gnucash-user
Hello, I'm using GNUCash 5.4, flathugb 5.4.1, finance quote 1.58 on Ubuntu 23.04.  I edited the template for invoices successfully.  However, when I go to a customer account and go to print an invoice, it changes to the default invoice template every time.  I've made the changes under Options an

Re: [GNC] I need basic help

2023-10-18 Thread Alan Johnson via gnucash-user
You need to assign each CC transaction to an expense account. E.g. McDonalds is "dining". When you pay down your CC, you make a transfer from you checking (or cash/etc) to the cc account. The expense categories will allow you to run reports and see what you are spending your money on. Your ch

Re: [GNC] Dealing with escrow account

2023-11-01 Thread Alan Johnson via gnucash-user
I structure my mortgage accounts like thus: - Asset account representing the property value (sub accounts for land / buildings as needed) - Loan/Liability account representing the amount borrowed which is transferred to the Property Asset account - Closing costs from the HUD-1 should also be accou

Re: [GNC] Dealing with escrow account

2023-11-02 Thread Alan Johnson via gnucash-user
Your mortgage payment should be fixed, adjusting one a year for escrow review.  You can automate / enter a year's worth of payments from bank to mortgage account.   You should also have a the 360 (or other) payment amortization table as part of your loan packet which shows you what each payment w

[GNC] How to change date of balance on register?

2023-12-10 Thread Alan Johnson via gnucash-user
Hello, I'm running GnuCash 5.4.1 flathub.   Is there a way to change the date of balance shown in the account overview? For example, I have a checking account with 10,000 in it today.  I have a couple transactions that are future dated which decrease the balance.  On the Accounts page, it shows

Re: [GNC] How to change date of balance on register?

2023-12-14 Thread Alan Johnson via gnucash-user
want a bit more "custom" then you can > enable view by 'Period' or 'Period (USD)' and then you can set the > period range in 'Edit' -> 'Preference' -> 'Accounting Period' > sheet.   > > -Original Message- >

[GNC] Monthly Expense summary Report

2023-12-14 Thread Alan Johnson via gnucash-user
Hello, Is there a way to have an expense report that breaks out the columns by week and/or month?  Other software will allow me to display the expense category for each month/quarter/week/chosen grouping period and then sum them at the end.  For example, In this report I could see how much I spe

Re: [GNC] Monthly Expense summary Report

2023-12-14 Thread Alan Johnson via gnucash-user
rom the one you want to focus on. > > Regards, > Adrien > > On 12/14/23 9:17 AM, Alan Johnson via gnucash-user wrote: > > Hello, > > > > Is there a way to have an expense report that breaks out the > > columns by > > week and/or month? > > > >

Re: [GNC] Monthly Expense summary Report

2023-12-14 Thread Alan Johnson via gnucash-user
(Transaction or Budget) should allow you to > select any accounts you want. > > Regards, > Adrien > > On 12/14/23 12:19 PM, Alan Johnson via gnucash-user wrote: > > Thanks, > > > > That will work. Only annoyance is that I can't seem to select both > > in

[GNC] Discount / Coupon question - How to apply?

2023-12-30 Thread Alan Johnson via gnucash-user
Hello, I have a customer that I have created an invoice for.  How do I create a coupon/discount to pay for the invoice and charge it to a marketing expense? I tried to choose the expense account but it will only allow me to use income or liability accounts. Thanks, Alan smime.p7s Description:

Re: [GNC] Discount / Coupon question - How to apply?

2023-12-31 Thread Alan Johnson via gnucash-user
fo, then commit the payment. > > Regards, > Adrien > > On 12/30/23 6:16 PM, Alan Johnson via gnucash-user wrote: > > I have a customer that I have created an invoice for. > > > > How do I create a coupon/discount to pay for the invoice and charge > > it > &

Re: [GNC] Discount / Coupon question - How to apply?

2024-01-02 Thread Alan Johnson via gnucash-user
esired expense account. (moving the amount from contra- > sales > to expense) > > Regards, > Adrien > > On 12/31/23 1:38 PM, Alan Johnson via gnucash-user wrote: > > Adrien, > > > > I tried that and I get the below error message: > > > > The

Re: [GNC] Discount / Coupon question - How to apply?

2024-01-03 Thread Alan Johnson via gnucash-user
I'm not a coder, but I've considered learning to give it a shot :) Alan On Tue, 2024-01-02 at 12:34 -0500, Derek Atkins wrote: > > > On Tue, January 2, 2024 12:31 pm, Alan Johnson via gnucash-user > wrote: > > Thanks, that worked.  > > > > Perhaps a

Re: [GNC] Discount / Coupon question - How to apply?

2024-01-03 Thread Alan Johnson via gnucash-user
ntermediary account) > > Regards, > Adrien > > On 1/2/24 11:31 AM, Alan Johnson via gnucash-user wrote: > > Thanks, that worked. > > > On Sun, 2023-12-31 at 14:36 -0600, Adrien Monteleone wrote: > > > Is this screenshot taken while viewing the AR account? That e

[GNC] Issues importing transactions (not matching)

2024-02-04 Thread Alan Johnson via gnucash-user
Hello, I'm attempting to import transactions from a credit card QFX file / Quicken format.   I have the pre-entered transaction as 'LEGO' in the amount of 45.14.  The imported transaction is "LEGO Enfeild CT" in the amount of 45.14.  Gnucash thinks these are not the same - and there are a numbe

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Alan Johnson via gnucash-user
ld be able to have header row(s), perhaps remove it and try > again. > > The Documentation for this is worded oddly, but the samples provided don't > show header info at all. > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > R

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Alan Johnson via gnucash-user
gt; Although you should be able to have header row(s), perhaps remove > > it and try again. > > > > > > The Documentation for this is worded oddly, but the samples > > provided don't show header info at all. > > > > > > > > https://www.gn

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Alan Johnson via gnucash-user
able to successfully able to import the bills.   Alan On Sat, 2024-02-24 at 19:10 -0500, Alan Johnson via gnucash-user wrote: > I did read the manual, hence my usage of the quotes. I had done it > before without.   > > I'll make a video and send it out shortly.  > > Alan

Re: [GNC] split transaction description field length limit

2024-03-03 Thread Alan Johnson via gnucash-user
I suggest you put your handyman in as a vendor. Then you can create a bill with long descriptions per item, and then pay the bill with a check. If you want to see what was paid, right click on the payment entry in the register and choose jump to invoice/bill. You can also run a vendor report. M

Re: [GNC] split transaction description field length limit

2024-03-04 Thread Alan Johnson via gnucash-user
ave > been spoiled by having reports from Quicken that provide the detail > associated with each expense account in a form that's easy to double > check. >   > Thank you again for trying to help with my problem. >   > Tim >   > From: Alan Johnson > Sent: Monday, Marc

Re: [GNC] Bill total does not match real total

2024-03-07 Thread Alan Johnson via gnucash-user
It may not wholly be a GNC problem, but a vendor software problem. Having entered numerous bills from Amazon and Costco recently, there have been a few cases where the sales tax did not match. This required an additional line item to adjust the sales tax to make the totals match. Entering bills

Re: [GNC] Bill total does not match real total

2024-03-11 Thread Alan Johnson via gnucash-user
I've looked at odoo, but haven't decided to pull the trigger on it. To use the sales/accounting features you need to subscribe and I'm not ready for that yet with my business needs.  On Sun, 2024-03-10 at 13:58 -0500, Mark via gnucash-user wrote: > Mar 10, 2024 11:01:45 Michael or Penny Novack >

Re: [GNC] trying to use good gnucash billing in personal books

2024-03-11 Thread Alan Johnson via gnucash-user
ere was a way I could set up accounts payable that > would hold bills inside my personal books with line items that > referred to expense accounts in my personal books. Is there a way to > do that and I'm I just not seeing it? >   > Tim >   > From: timothyscu...@yahoo.com

Re: [GNC] Bill total does not match real total

2024-03-15 Thread Alan Johnson via gnucash-user
I looked at the trial. The core they offer has a number of modules you can use for free/self hosted/open source.  The accounting packages require a subscription/paid service.   On Mon, 2024-03-11 at 11:56 -0500, Adrien Monteleone wrote: > I'm not sure if it is still entirely open source, but it st

Re: [GNC] Import matching

2024-04-23 Thread Alan Johnson via gnucash-user
For Amazon, your best bet is to use the vendor functions. , You can create the total invoice in GNC and then apply the payments to the invoice (which, on  orders with many items may be 3-4 payments). Alternatively, you have to do janky things with placeholder transactions. Apr 23, 2024 11:01:45

Re: [GNC] Import matching

2024-04-23 Thread Alan Johnson via gnucash-user
Amazon doesn't split it into multiple invoices, but multiple payments per invoice. When you go into Amazon and go to Your Orders, click the *show invoice* link. At the bottom it will show you the payment break down (taxes, gift card, each CC payment made etc) GNC will process this just fine. Ju

Re: [GNC] Fund management without an actual account

2024-08-05 Thread Alan Johnson via gnucash-user
I would suggest a sub account under your bank account, which will have the effect of reducing your available cash balance, so you don't spend it. If you need to spend it, then you can transfer from assetts:savings:vacation to assetts:checking to spend it. Also, you could open another savings ac

[GNC] Fwd: Fund management without an actual account

2024-08-05 Thread Alan Johnson via gnucash-user
Daniel, I would suggest that you use the second savings account and it would help with the over spending. I think it would look something like this, please forgive formatting as I'm on mobile, but you should get the idea. Checking debit 10k / salary credit 10k Credit checking 1k / debit savin

Re: [GNC] Fwd: Fund management without an actual account

2024-08-06 Thread Alan Johnson via gnucash-user
he face of computing, and the Spirit of ARPA > moved upon the face of the computers. Then Kibo said, "Let there be data": > and there was data. Kibo saw the data, and it was good, so Kibo divided the > data from the randomness, and Kibo named the data Information, and th

Re: [GNC] Fwd: Fund management without an actual account

2024-08-06 Thread Alan Johnson via gnucash-user
was data. Kibo saw the data, and > it was good, so Kibo divided the data from the randomness, and Kibo > named the data Information, and the randomness Clueless. And the > Information and the Clueless were the first Network. > > > On Wed, Aug 7, 2024 at 3:54 AM Alan Johnson &g

Re: [GNC] GNC 5.9 - Loss of suggestions when completing customer/vendor name?

2024-10-17 Thread Alan Johnson via gnucash-user
Well, I was in the bank register after having imported transactions. I selected Apply as Payment and then was in the dialog box. I repeated this several times for the same customer, but it still did not suggest the customer account. smime.p7s Description: S/MIME cryptographic signature

[GNC] GNC 5.9 - Loss of suggestions when completing customer/vendor name?

2024-10-17 Thread Alan Johnson via gnucash-user
Hello, Previously, I was able to enter the first few letters of either the Customer or Vendor name when entering a payment or creating a bill, then I could pick from the drop down list. This seems to have gone away in 5.9 Flathub. Is there a way to turn this back on? It is rather cumbersome to hav

[GNC] Invalid transaction type L

2025-03-18 Thread Alan Johnson via gnucash-user
Hello, I ran a Receivable Aging report and it has the following error message at the bottom: Please note some transactions were not processed 1. Invalid Txn Type L When I click the link, it takes me to a invoice with a credit memo, with a partial balance: How do I resolve this error? Alan s

Re: [GNC] Invalid transaction type L

2025-03-19 Thread Alan Johnson via gnucash-user
> > always > > delete the payment later from the bank account), and check (or re- > > apply) > > the credit note. > > > > back up the datafile before you experiment, of course! > > > > which version of GC and OS are you on? > > >

[GNC] Gnucash crashing when trying to open a different file

2025-04-23 Thread Alan Johnson via gnucash-user
I have GnuCash 5.11 build date 2025-03-29, installed from a PPA on Ubuntu 24.10/Oracular.  It opens fine, but when I try to open a different gnucash file, it quits. The following error(s) were logged in syslog: 2025-04-23T16:41:23.470467-04:00 fafnir systemd[5359]: Started app- gnome-gnucash-3316

[GNC] Customer Reports for every customer

2025-03-13 Thread Alan Johnson via gnucash-user
Hello, Is there a way to generate / export a Customer Report for every active customer? If I have 30 customers, is there a way to get each report printed to its own file in a specified directory for all (or selected) customers for a given date range (e.g. accounting period or manually specified)?