Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
Weird. Without that bill, do the vendors show but with everything as zero balances? If not, try Options > General > Show zero balance items. If that works and your balances are all zero as of the end of Feb '22, then your A/P as of that date was indeed zero. Any discrepancy otherwise

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread David Kirkby
On Tue, 28 Nov 2023 at 15:35, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > On 11/28/23 5:34 AM, David Kirkby wrote: > > > > If I go to Reports > Business > Payable Aging, I just see > > > > > > > > *Payable Ageing - 28/11/2023A/Payable or A/Receivable accounts exist but > > have

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
On 11/28/23 5:34 AM, David Kirkby wrote: On Tue, 28 Nov 2023 at 10:35, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: Neither of those is an Accounts Payable Aging Report. I'm not certain what the first one is. The second is a Transaction Report. Go to Reports > Business >

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread David Kirkby
On Tue, 28 Nov 2023 at 10:35, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Neither of those is an Accounts Payable Aging Report. > > I'm not certain what the first one is. The second is a Transaction Report. > > Go to Reports > Business > Payable Aging > > Regards, > Adrien > If

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
Neither of those is an Accounts Payable Aging Report. I'm not certain what the first one is. The second is a Transaction Report. Go to Reports > Business > Payable Aging Regards, Adrien On 11/27/23 4:58 PM, David Kirkby wrote: [image: image.png] [image: image.png]

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
Not so. Go back and read my replies again. You absolutely can get what you are looking for after the fact. Most accountants just want the total AP number. But if you need to provide it by Vendor, I've given you the steps to get that info. Regards, Adrien On 11/27/23 7:08 PM, David Kirkby

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
The Payables Aging Report will tell you the *amount* that is outstanding, and to who, and with an aging time frame, as of the date of the report. Once you have the Payables Aging Report - you know who you owed money to as of that date and how much. To see which bills that entails, you have

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread kirk abbott via gnucash-user
Okay, I can see two ways to go from here. First try using the Vendor Report. That one provides the option selecting both the beginning and ending date to be used. If that doesn't do it, checking the individual vendor accounts should provide the information needed. Kirk On Monday, November

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread David Kirkby
On Tue, 28 Nov 2023 at 02:26, David Carlson wrote: > David, > > While I am not conversant with your basic issue, I have not seen where you > account for the fact that every time money is exchanged from one currency > to another, there is a specific exchange rate and possibly fees that apply >

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread David Carlson
David, While I am not conversant with your basic issue, I have not seen where you account for the fact that every time money is exchanged from one currency to another, there is a specific exchange rate and possibly fees that apply only to that specific transaction. Then the next transaction most

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread David Kirkby
On Tue, 28 Nov 2023 at 02:01, kirk abbott wrote: > I just took another look at the PNG's, and it looks like you might not be > using the A/P module correctly. To ascertain this, I would like to ask if > you have setup vendor accounts. They would be the normal way for entering > A/P expenses. > >

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread kirk abbott via gnucash-user
I just took another look at the PNG's, and it looks like you might not be using the A/P module correctly. To ascertain this, I would like to ask if you have setup vendor accounts. They would be the normal way for entering A/P expenses. Kirk On Monday, November 27, 2023 at 05:08:42 PM PST,

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread David Kirkby
On Tue, 28 Nov 2023 at 00:57, kirk abbott wrote: > They probably won't match, ever . Basically the starting balance plus the > account total will equal the ending balance. The beginning balance seems to > be set to whatever the last balance was prior to period of the report > generated. If you

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread kirk abbott via gnucash-user
They probably won't match, ever . Basically the starting balance plus the account total will equal the ending balance. The beginning balance seems to be set to whatever the last balance was prior to period of the report generated. If you check the account balance prior to 01/03/2022 you may

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread kirk abbott via gnucash-user
While looking at the report, click on 'Options' on the menu bar. General options should allow you to select the date that you want. Kirk On Monday, November 27, 2023 at 12:42:13 PM PST, David Kirkby wrote: On Mon, 27 Nov 2023 at 20:08, Adrien Monteleone <

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread Maf. King
On Monday, 27 November 2023 20:41:52 GMT David Kirkby wrote: > Business -> Payable Ageing > > gives me what is owned *today*, which is nothing. Can I find out what was > owed at the end of the accounting period? That's what I want. Short of > perhaps changing the date on the computer, which I'd

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread David Kirkby
On Mon, 27 Nov 2023 at 20:08, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > There's an Payable Aging Report. You can then click the total amounts > owed for each Vendor to see which documents are outstanding. (this runs > a Vendor Report) If you set the option on the Vendor Report

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread Adrien Monteleone
There's an Payable Aging Report. You can then click the total amounts owed for each Vendor to see which documents are outstanding. (this runs a Vendor Report) If you set the option on the Vendor Report for detailed links, you'll see which payments were applied to which bills and which bills

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread David Kirkby
On Mon, 27 Nov 2023 at 18:51, david whiting wrote: > Does setting the date in the report Options give you what you need? > You should be able to see where there are amounts payable for each > vendor and if you click on the value link it will take you to the > vendor report for that same date. Is

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread david whiting
Does setting the date in the report Options give you what you need? You should be able to see where there are amounts payable for each vendor and if you click on the value link it will take you to the vendor report for that same date. Is that what you are looking for? David On Mon, 27 Nov 2023

[GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread David Kirkby
I have given my accounts to my accountant, who has asked for a breakdown of the what transactions are in the accounts payable, as there's £353.90 shown on A/P at the end of the accounting period. Since whatever was owed has now been paid, I can't find what was owed on that date. There's no single