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

2024-08-06 Thread Alan Johnson via gnucash-user
t; > > > > > > > But sub accounts on my checking account seems to be the > > > prevailing view... probably for a reason... perhaps I should try > > > harder... > > > > > > > > > > > > > > > Cheers, > >

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

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

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

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

2024-03-11 Thread Alan Johnson via gnucash-user
; >   > > I think that this would be the best way to handle the handyman > > payments as requested and job tracking (create various expense > > accounts). It would also allow for multiple types of payments - > > e.g. check, credit card, cash all on the same bill if needed.   &g

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 bills

Re: [GNC] split transaction description field length limit

2024-03-04 Thread Alan Johnson via gnucash-user
reen > > you cannot directly see anything that is after a linefeed character > > unless you scroll past that character since the 'window' is one > > line tall. > >   > > I do not use business features so I don't have invoices or > > vendors.  Another

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] 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] 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
egards, > Adrien > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: >> Hello, >> I'm having some issues importing a bill via CSV. I set up a trial run >> and I'm getting the below errors.  Vendor "05" does not exist, >> however that is th

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

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

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

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

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

[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] How to change date of balance on register?

2023-12-14 Thread Alan Johnson via gnucash-user
From: David H > Sent: Sunday, December 10, 2023 5:32 PM > To: Alan Johnson > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] How to change date of balance on register? > > If you click on the down arrow in the header line of the accounts tab > far right you can select lots

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

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

[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