Re: [GNC] Tracking UnPaid Bills

2025-04-05 Thread Murugan Mariappan
recognized in the period in which they are incurred, not necessarily when they are paid. Saludos Cordiales Murugan From: Michael or Penny Novack Sent: 20 March 2025 13:16 To: Murugan Mariappan ; gnucash-user@gnucash.org Subject: Re: [GNC] Tracking UnPaid Bills

Re: [GNC] Tracking UnPaid Bills

2025-04-05 Thread R Losey
On Wed, Mar 19, 2025 at 4:19 PM flywire wrote: > On Thu, 20 Mar 2025 at 06:30, flywire wrote: > > > So how do you propose actually tracking unpaid bills? Recording a > > transaction doesn't do it. It would normally involve specific reports run > > frequently enough to manage payments due. > > > H

Re: [GNC] Tracking UnPaid Bills

2025-04-05 Thread Michael or Penny Novack via gnucash-user
On 3/19/2025 5:17 PM, flywire wrote: So how do you propose actually tracking unpaid bills? Recording a transaction doesn't do it. It would normally involve specific reports run frequently enough to manage payments due. Hmm, no mention of any specific reports to understand what is in the liabili

Re: [GNC] Tracking UnPaid Bills

2025-04-05 Thread Derek Atkins
Hi, You are doing something wrong. So let me ask you a question: How does the refund work in real-life? My guess is that the refund is actually a "reduction of expense" -- because it's coming from the Vendor directly. It should probably not hit the liability account at all, unless the goal is t

Re: [GNC] Tracking UnPaid Bills

2025-04-04 Thread Maf. King
On Thursday, 20 March 2025 15:08:12 GMT Michael or Penny Novack via gnucash- user wrote: > > PS --- I have a question for gnucash folks using the business features. > How do you treat (what date do you use) incoming bills that are NOT "due > upon receipt" but instead "due at some future date"? An

Re: [GNC] Tracking UnPaid Bills

2025-03-26 Thread Michael or Penny Novack via gnucash-user
Answer I use the business feature, which utilizes three types of dates: - Bill Date: The date on the bill from the seller. - Post Date: The date you post the bill into your books. - Due Date: The date the bill is due. You can predefine payment terms like net 30 or define your own. When you pay

Re: [GNC] Tracking UnPaid Bills

2025-03-22 Thread G R Hewitt
>From the UK too. Tax date for me, logical, then everyone can find the right invoice as well as they were filed in date order. On Thu, 20 Mar 2025 at 19:39, Maf. King wrote: > On Thursday, 20 March 2025 15:08:12 GMT Michael or Penny Novack via > gnucash- > user wrote: > > > > > PS --- I have a

Re: [GNC] Tracking UnPaid Bills

2025-03-21 Thread flywire
I have updated https://wiki.gnucash.org/wiki/Using_GnuCash#Printing_a_Rental_Report which would be well worth someone with a sound accounting background checking. I also consider hybrid accounting is worth a mention in the Guide. Regards > ___ gnucash-u

Re: [GNC] Tracking UnPaid Bills

2025-03-20 Thread Michael or Penny Novack via gnucash-user
On 3/20/2025 12:49 PM, Murugan Mariappan wrote: The effective date for recording the expense transaction should be based on when the goods or services are received rather than the due date of the bill or the credit period provided by the vendor. This aligns with the accrual basis of accounti

Re: [GNC] Tracking UnPaid Bills

2025-03-20 Thread Murugan Mariappan
m: gnucash-user on behalf of Michael or Penny Novack via gnucash-user Sent: 20 March 2025 12:08 To: gnucash-user@gnucash.org Subject: Re: [GNC] Tracking UnPaid Bills On 3/19/2025 5:17 PM, flywire wrote: >> So how do you propose actually tracking unpaid bills? Recording a >> tra

Re: [GNC] Tracking UnPaid Bills

2025-03-20 Thread flywire
On Thu, 20 Mar 2025 at 06:30, flywire wrote: > So how do you propose actually tracking unpaid bills? Recording a > transaction doesn't do it. It would normally involve specific reports run > frequently enough to manage payments due. > Hmm, no mention of any specific reports to understand what is i

Re: [GNC] Tracking UnPaid Bills

2025-03-20 Thread David Cousens
Then you would create asset accounts (an equivalent to the accounts payable in business features) for rent owed. Again you could use sub- accounts for each property to a fine a scale as needed. When the rent is due on a property you create an entry with a debit to the appropriate Asset:Rent Owed

Re: [GNC] Tracking UnPaid Bills

2025-03-20 Thread Doug via gnucash-user
Thanks. I had found that link before (but will revisit it) What I would like is a report I could hand to the tenant (monthly, or 3 Monthly) that had all income & recompense due to that tenant with a total credit or debit at the bottom ie rent in advance, or arrears. Of course I want it to be e

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread flywire
Try the pdf file: > Rent.pdf Description: Adobe PDF document ___ 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

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread flywire
The approach discussed in this thread seems workable for rental properties. Attached is a sample rent Transaction Report. The transactions are shown in Assets:Rent Owing (ie A/R) account which could be used as a tenant rent report if the Debit/Credit column labels were changed to something like Pa

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread Liz
On Thu, 20 Mar 2025 10:38:40 +1100 Doug via gnucash-user wrote: > What I would like is a report I could hand to the tenant (monthly, > or 3 Monthly) that had all income & recompense due to that tenant > with a total credit or debit at the bottom ie rent in advance, or > arrears. Of course I w

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread flywire
On Wed Mar 19 16:57:40 EDT 2025 Doug wrote: > I have an issue tracking rental property income A reasonable solution to this is a fairly common issue would be a good outcome from this thread. It doesn't seem easy to report with the accounts cutting across Balance Sheet, Income and Expense, and Tra

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread Doug via gnucash-user
The only issue with this tracking for business use is that some can be income related. I have an issue tracking rental property income: I need to work out a way of only having rent payment as income (cash accrual), but being able to generate reports that track rental payments with the property r

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread Michael or Penny Novack via gnucash-user
On 3/19/2025 3:30 PM, flywire wrote: The transactions are working the way they are supposed to, so thank you everyone who contributed to this topic. So how do you propose actually tracking unpaid bills? Recording a transaction doesn't do it. It would normally involve specific reports run frequent

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread David Cousens
You can always make the tracking of bills as fine scale as you need by creating a specific sub account strucure to the liability account e.g Liability-Utilities- Electricity -Water -Internet -Loans-House -Car etc. Then the l

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread Griffin
The method that is now working me is as follows. When the bill arrives, create a transaction in the expense register, with the liability account as the other account. Increase the expense account by the value of the bill. This will also increase the balance of the liability. The liability balan

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread flywire
On Wed Mar 19 10:07:19 EDT 2025 griffin wrote: > > The transactions are working the way they are supposed to, so thank > you everyone who contributed to this topic. So how do you propose actually tracking unpaid bills? Recording a transaction doesn't do it. It would normally involve specific repor

Re: [GNC] Tracking UnPaid Bills

2025-03-19 Thread griffin
So I think I've made a discovery. For some reason things are working how they should, and when I went back over what I had done I realised that I turned off the setting "Reverse Balanced Accounts". The trans actions are working the way they are supposed to, so thank you everyone who contribu

Re: [GNC] Tracking UnPaid Bills

2025-03-18 Thread Derek Atkins
Hi. Please remember to CC gnucash-user on all replies... Define "overpaid". Going step-by-step: 1. Liability -> Expense(e.g. you are billed for $50) 2. Bank -> Liability (e.g. you over-pay $75) .. At this point, the Liability should say that they owe you! 3. Liability -> Bank (e

Re: [GNC] Tracking UnPaid Bills

2025-03-18 Thread Murugan Mariappan
iales Murugan From: gnucash-user on behalf of Derek Atkins Sent: 18 March 2025 14:22 To: griffin Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Tracking UnPaid Bills Hi, You are doing something wrong. So let me ask you a question: How does the refund work in

Re: [GNC] Tracking UnPaid Bills

2025-03-18 Thread griffin
Sorry, but I'm still having an issue with this process. Setting the bill value as a transfer from the expense account to the liability account is working fine, as is paying off the liability from the chequing account. However, dealing with a refund is still causing a problem. 1.) If I make a

Re: [GNC] Tracking UnPaid Bills

2025-03-17 Thread R Losey
Liability accounts are normally "negative"; charges accrue in the right column "Increase", and payments show up in the left column ("Decrease"). If you have a credit amount, it should be a positive number. Your account was zero on 18 Feb, but you show a new "charge" of 34.84 -- I think that's the e

Re: [GNC] Tracking UnPaid Bills

2025-03-17 Thread griffin
I have been trying this, and I've hit a small issue. I made an over payment to my phone bill, and then moved to another carrier, so I was over paid in the liability account. When I tried to "refund" this overpayment to my chequing account GnuCash either doubles the liability, or withdraws the

Re: [GNC] Tracking UnPaid Bills

2025-03-17 Thread R Losey
On Sun, Mar 16, 2025 at 11:56 AM Michael or Penny Novack via gnucash-user < gnucash-user@gnucash.org> wrote: > On 3/16/2025 12:13 AM, R Losey wrote: > > Hi. I'd just set such accounts up as sub-accounts under Liabilities. > Using > > your example (electricity) > > > > 1) Create an "Electricity" ac

Re: [GNC] Tracking UnPaid Bills

2025-03-16 Thread Michael or Penny Novack via gnucash-user
On 3/16/2025 5:31 PM, flywire wrote: I understand this to be a request for Hybrid Accounting, basically a combination of Cash Accounting and Accrual Accounting. (Rental Income being the other side of the ledger tracking unpaid Invoices - Accounts Receivable). A bill you receive is a liability. F

Re: [GNC] Tracking UnPaid Bills

2025-03-16 Thread Michael or Penny Novack via gnucash-user
On 3/16/2025 12:13 AM, R Losey wrote: Hi. I'd just set such accounts up as sub-accounts under Liabilities. Using your example (electricity) 1) Create an "Electricity" account under "Liabilites" (alternatively, you could use the provider as the name of the account 2) Using your $120 bill as an ex

Re: [GNC] Tracking UnPaid Bills

2025-03-15 Thread Liz
On Sat, 15 Mar 2025 23:13:47 -0500 R Losey wrote: > Hi. I'd just set such accounts up as sub-accounts under Liabilities. > Using your example (electricity) > > 1) Create an "Electricity" account under "Liabilites" (alternatively, > you could use the provider as the name of the account > 2) Using

Re: [GNC] Tracking UnPaid Bills

2025-03-15 Thread R Losey
Hi. I'd just set such accounts up as sub-accounts under Liabilities. Using your example (electricity) 1) Create an "Electricity" account under "Liabilites" (alternatively, you could use the provider as the name of the account 2) Using your $120 bill as an example, when you pay $60 and owe them $60

Re: [GNC] Tracking UnPaid Bills

2025-03-15 Thread Doug via gnucash-user
As a comment, I feel not having an easier form of tracking is something that possibly might be fixed in the future. I have Rental properties, & tried to set up an AP & AR for them but found it a bit daunting. (Awfully hard to undo too!). I do need a rental management system though. Most renters

Re: [GNC] Tracking UnPaid Bills

2025-03-15 Thread Michael or Penny Novack via gnucash-user
Yes, you COULD switch to accrual basis accounting. In which case you would enter the bill into "payables" (and the example expense "electricity). But doing that in personal accounting where MOST expenses not billed might be excessive << you are in effect naturally "cash basis" for most of your

Re: [GNC] Tracking UnPaid Bills

2025-03-15 Thread Derek Atkins
Use the business Vendor Bill feature. It's a lot more work, but will do what you want. -derek Sent using my mobile device. Please excuse any typos. On March 15, 2025 17:10:59 griffin wrote: I think I'm starting to mess up my accounts. I use GnuCash for my home accounts. I know little/nothing a

Re: [GNC] Tracking UnPaid Bills

2025-03-15 Thread David Cousens
Louise, The invoice and bills Business Features in GnuCash are setup specifically for monitoring payables (what you owe) and receivable (what is owed to you). They work using two special accounts, a Liability account "Accounts Payable " and an asset account "Accounts Receivable". AFAIK they are e

Re: [GNC] Tracking UnPaid Bills

2025-03-15 Thread G R Hewitt
Probably the easiest method would be to set up the companies as suppliers, using Gnucash's business function; when the bill comes in enter it into their supplier account. Then when you make a payment record it against the supplier as a part payment of the invoice. You will then be able to see which