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.

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] 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

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

2024-03-11 Thread Alan Johnson via gnucash-user
ts 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 > Sent: Tuesday, March 5, 2024 6:52 AM >

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] 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

Re: [GNC] split transaction description field length limit

2024-03-04 Thread Alan Johnson via gnucash-user
ociated 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, March 4, 2024 7:43 AM > To: David Carlson > Cc: timothyscu...@yahoo.com; gnucash-

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.

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Alan Johnson via gnucash-user
fully 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 > > On Sun,

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Alan Johnson via gnucash-user
e 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/gnucas

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Alan Johnson via gnucash-user
ave 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 > > Regards, > Adrien

[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

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? Tha

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 future fe

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

2024-01-02 Thread Alan Johnson via gnucash-user
nt. (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 selected transactio

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

2023-12-31 Thread Alan Johnson via gnucash-user
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 > > to a market

[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

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 >

Re: [GNC] Monthly Expense summary Report

2023-12-14 Thread Alan Johnson via gnucash-user
e 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? > > > > Other soft

[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

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

2023-12-14 Thread Alan Johnson via gnucash-user
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- > From: David H > Sent: Sunday, December 10, 2023 5:32 PM > To: Alan Johnson >

[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] 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

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

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

[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

Re: Applying Customer overpayments

2018-02-08 Thread Alan Johnson
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 Johnson: Hello,

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