Renier Posted August 6, 2022 Share Posted August 6, 2022 How can I view my expenses over a period per supplier? I want to know how much have I spent during a certain period on a specific supplier. Link to comment Share on other sites More sharing options...
GRH Posted August 6, 2022 Share Posted August 6, 2022 Try this: Click 'Purchases' tab From left hand menu under 'Suppliers', click 'View Supplier List' Choose supplier from the list Click 'Statement' drop-down and choose 'Print Preview' Enter the period you want, click 'OK' A statement of account will appear, if it's what you want you can print it off. There may be other ways I haven't tried. Link to comment Share on other sites More sharing options...
Renier Posted August 7, 2022 Author Share Posted August 7, 2022 Thank you for the reply. I does not work. On the statement it there is total bills 0 and total payments 0. i need to know were my money is going to prevent wastage of money because of unnecessary expenses. Link to comment Share on other sites More sharing options...
GRH Posted August 7, 2022 Share Posted August 7, 2022 That is strange. In the suppliers list, is there an amount showing under the 'Accounts Payable' column against the suppliers account? Try this instead: Click 'Purchases' tab In the left hand column under 'Accounts Payable' choose 'View Accounts Payable'. From this pane, select the dates, and supplier from the drop-down menu - hopefully that will show some meaningful information. Unfortunately, Express Accounts can be very frustrating. An alternative, if it becomes problematical might, be Gnucash, which is well supported, open source and hence free, which I use, you can view it here https://www.gnucash.org/. Link to comment Share on other sites More sharing options...
Renier Posted August 8, 2022 Author Share Posted August 8, 2022 In the suppliers list under the 'Accounts Payable' column it is also 0. In the left hand column under 'Accounts Payable' there is only " enter new Accounts Payable". I will have a look at Gnucash, or maybe I must just buy Quickbooks. Link to comment Share on other sites More sharing options...
GRH Posted August 8, 2022 Share Posted August 8, 2022 That's odd, if you have created suppliers, and bought stuff from them, and input the transactions, there should be data there - invoices and payments. I'd give Gnucash a try, it is free and you have nothing to lose, save a little time. I particularly like the drill-down in reports, if you see, on the face of it, an unusual amount, clicking on it takes you to the entries where all is revealed. Once you get used to it, it's really quite powerful. Link to comment Share on other sites More sharing options...
SimonL Posted October 24, 2022 Share Posted October 24, 2022 +1 here on v9.01 I note that, if the purchases are made through the accounts payable / pay a bill workflow it reports correctly. Immediate/direct payments don't seem to track the vendor though. Link to comment Share on other sites More sharing options...
elk Posted October 24, 2022 Share Posted October 24, 2022 If you find your accounts are not balancing, try recalculating the balances in Express Accounts to see if it helps. To do this, click the Transactions menu option in the main window and select Recalculate Customers' Balances. Express Accounts will run a recalculation automatically. Link to comment Share on other sites More sharing options...
SimonL Posted October 25, 2022 Share Posted October 25, 2022 On 10/25/2022 at 2:56 AM, elk said: If you find your accounts are not balancing, try recalculating the balances in Express Accounts to see if it helps. To do this, click the Transactions menu option in the main window and select Recalculate Customers' Balances. Express Accounts will run a recalculation automatically. This has absolutely nothing to do with the topic being discussed here. Link to comment Share on other sites More sharing options...
SimonL Posted October 25, 2022 Share Posted October 25, 2022 Ok, Renier (and those who follow looking for the same thing). It's been interesting. After many emails, I finally got this out of the support team: Quote Thank you for contacting us, and we will forward your inquiries to the developers for further testing. I agree with you that it seems to be pointless to enter the vendor's details while entering a payment. As soon as I have details from the developers about this matter I will notify you by email. When I do a low level search of the files in the data directory, it seems that (for immediate payments) the vendor entered is not being stored - neither as the vendor name nor as the ID of the vendor. The only information stored for the transaction is what pops up in the journal. It looks like they're using the same form for data entry as the enter bill / enter payment workflow, but just ignoring some fields. So, until the developers decide to add a "direct payments" data structure and populate it with this stuff, we are humped. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now