[GNC] determining which Gnucash version last ran/MacOS
Hi all, I overstayed my time with 2.6.21 and recently downloaded a few versions in the 3, 4, and 5 families to start a cautious upgrade. Thing is, a few busy weeks intervened and now I can't remember how far I got. I'd hoped Finder would populate "Date Last Opened" but that's empty for all versions including 2.6.21. Getting info on my gnucash file results in "Open with: 3.11-1" and I'm willing to believe that's where I left off. But if there's a more certain way to determine the last version I ran I'd love to know what it is. I'm comfortable at a unix command line. TIA, Eric ___ 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 to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] automatically account for gst on random purchases
> On Jun 20, 2023, at 00:11, flywire wrote: > > > There is an incredible amount of keystrokes, clicks, and human memory > recall to pay a bill: > > Business, Vendor, New Bill, Date Opened:20/06/2023, Vendor: Random, OK > Expense account: Expenses:Auto:Fuel, Quantity: 1, Taxable, Tax included: > Select, Tax Table: GST on Purchases [default] > Enter > Post bill (so it can be paid), OK > Pay, Select Transfer Account: Checking Account, OK > > Sample Transaction > Date Description >AccountDebit Credit > 20/06/23 Random >Expenses:Auto:Fuel $3,000.00 >Liabilities:GST:GST on Purchases $300.00 That's a mistake, you got it right below >Assets:Current Assets:Checking Account $3,300.00 > > General Journal > Date Description >AccountDebit Credit > 20/06/23 Random >Liabilities:Accounts Payable $3,300.00 >Assets:Current Assets:Checking Account $3,300.00 > 20/06/23 Random >Assets:GST:GST on Purchases $300.00 >Expenses:Auto:Fuel $3,000.00 >Liabilities:Accounts Payable$3,300.00 Does Australia let you deduct GST on overhead expense from that paid on product sold, or only VAT incurred in COGS? If it's only the latter I'd think auto fuel would be a poor example. The problem with your proposal if you change that to some actual input--a process chemical, say--is that you don't expense those when you purchase them: It's an asset transfer, DR Assets:Inputs:Process Chemicals:SF6 (just picking a random process chemical from one of my former lives in semiconductor manufacturing), DR Assets:GST:GST on inputs, CR Liabilities:Accounts Payable. Expending the process chemical is another asset transfer, DR WIP, CR inputs *and* DR GST on WIP, CR GST on Inputs. When the product is finished its transferred from WIP to Finished inventory and the accumulated GST would be transferred too: DR Finished Inventory, CR WIP and DR GST on finished inventory, CR GST on WIP. You book the expenses when you sell product: DR:Assets:Accounts Receivable, CR Income:Sales, DR Expenses:COGS, CR Assets:Finished Inventory; DR Expenses:GST on sales, CR:GST on finished inventory, CR Liabilities:GST. To make that work the way you say that Quickbooks does it you'd need the Expenses:COGS to be broken out by product and each product's BOM and break out the right proportion of each sale into each BOM account. That seems to me to be more complicated than separating the value and GST at purchase time. GnuCash has tax tables on bills just like on invoices, so once you've set up your input GST schedules you only need to apply the right one to each line item. You'll have two sets, one for inputs that goes to an asset account and one for overhead that goes to an expense account. If your GST/VAT regime has a lot of different rates then take some care naming your tax tables so it's easy to remember which one to apply to each line item. But either way it's a lot of manual work. That's why I keep repeating that GnuCash is suitable only for very small retail operations and completely unsuitable for any sort of manufacturing. There's better software out there for those kinds of businesses. Don't waste time trying to convince us to turn GnuCash into a competitor for Odoo (it isn't going to happen, we don't have the resources), just use Odoo if that's what you need. Geert does, so what better endorsement do you need? Regards, John Ralls ___ 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 to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] automatically account for gst on random purchases
On Tue, 20 Jun 2023 17:11:59 +1000 flywire wrote: > There is an incredible amount of keystrokes, clicks, and human memory > recall to pay a bill: That would be a reason I don't use that part of the business features. For invoicing I use the business features as it is worthwhile, even when I get an invoice provided by the paying entity. Liz ___ 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 to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] automatically account for gst on random purchases
On Tue, 20 Jun 2023 at 10:58, David Cousens wrote: > AFAIK the tax tables work only with with invoices. As not all items are > necessarily subject to GST in all business situations in AU. It would be > difficult to automate it because of this and similarly with applying it to > imported transactions, GnuCash has no way of knowing what items are > subject to GST and which are not. I haven't had to do GST returns since > 2014 when I retired but if my memory serves me I had to creatte invoices > for any requiring GST or manually enter it myself. > > David > > https://lists.gnucash.org/pipermail/gnucash-user/2023-June/107428.html > flywire wrote: > > ... > USA user comments tend to imply GnuCash uses a USA Point-Of-Sale model for Invoicing and Billing. Attaching the tax code to the income/expense account (like Quickbooks) would be much more efficient for other countries like Australia. As David noted above tax might not be simple. While most Australian businesses apply GST, normally 10%, some are input taxed so they cannot claim the GST on those enterprises, and businesses may have both types of enterprises. For example, a farm business might have to split fuel by enterprise if say the farm enterprise pays and collects GST and the business also rents worker residential accommodation enterprise paying GST it is not entitled to claim, collect, or have any reason to account for. Businesses aim to make money and GST is charged on that money so it follows GST is a liability. Another nice thing Quickbooks does contrary to the Guide is place all the GST accounts under liabilities so the net result is clear from the parent account at any time. [Liability:GST:GST on Sales (ie tax collected) and Liability:GST:GST on Purchases (ie tax paid).] I'm going to come back with a preprocessing solution but it could be done directly and more efficiently by the importer using the tax table. - I'll close this post with most steps for the Minimal Working Example based on inconsistent documentation previously linked: Run GnuCash File, New New Account Hierarchy Setup, Next New Book Options, Next Choose Currency, Next Choose accounts to create: Select Business Accounts and Clear Common Accounts, Finish Apply File: GST-Demo, Save As Actions, New account Create Assets:GST:GST on Purchases and Liabilities:GST:GST on Sales Business, Sales tax table Create tax tables: GST on Purchases, Tax table entries: Assets:GST:GST on Purchases GST on Sales, Tax table entries: Liabilities:GST:GST on Sales Close File, Properties, Business tab Default Customer Tax Table: GST on Sales, Default Vendor Tax Table: GST on Purchases Business, Vendor, New Vendor, Company Name: Random, OK There is an incredible amount of keystrokes, clicks, and human memory recall to pay a bill: Business, Vendor, New Bill, Date Opened:20/06/2023, Vendor: Random, OK Expense account: Expenses:Auto:Fuel, Quantity: 1, Taxable, Tax included: Select, Tax Table: GST on Purchases [default] Enter Post bill (so it can be paid), OK Pay, Select Transfer Account: Checking Account, OK Sample Transaction Date Description AccountDebit Credit 20/06/23 Random Expenses:Auto:Fuel $3,000.00 Liabilities:GST:GST on Purchases $300.00 Assets:Current Assets:Checking Account $3,300.00 General Journal Date Description AccountDebit Credit 20/06/23 Random Liabilities:Accounts Payable $3,300.00 Assets:Current Assets:Checking Account $3,300.00 20/06/23 Random Assets:GST:GST on Purchases $300.00 Expenses:Auto:Fuel $3,000.00 Liabilities:Accounts Payable$3,300.00 Regards ___ 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 to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.