Quickbooks custom field for computing a value
Custom fields are limited to non-calculated values.  Read more here:  http://qbblog.ccrsoftware.info/2008/07/custom-fields-in-quickbooks/ To do this you will need an add-on.  I would reccomend CCRQInvoice, but only because its the only one I've tried and it worked.  More here (this is an order form example, but it works): http://ccrqblog.ccrsoftware.info/adding-calculated-fields-to-order-forms/ The product info is here: http://www.ccrsoftware.com/CCRQInvoice/InvoiceQ.htm
"Gnucash is first and foremost just a general ledger system. It tracks money in accounts, and lets you make transactions to transfer money between the accounts, but it has no inherent concept of things like taxes. This gives you a large amount of flexibility to organize your account hierarchy the way you want, but also means that it sometimes can take a while to figure out what account hierarchy you want. The idea is that you keep track of where you get money from (the Income accounts), what you have as a result (the Asset accounts), and then track what you spent the money on (the Expense accounts). It sounds like you primarily think of expenses as each being for a particular property, so I think you want to use that as the basis of your hierarchy. You probably want something like this (obviously I'm making up the specifics): Now, when running transaction reports or income/expense reports, you can filter to the accounts (and subaccounts) of each property to get a report specific to that property. You mention that you also sometimes want to run a report on ""all gas expenses, regardless of property"", and that's a bit more annoying to do. You can run the report, and when selecting accounts you have to select all the Gas accounts individually. It sounds like you're really looking for a way to have each transaction classified in some kind of two-axis system, but the way a general ledger works is that it's just a tree, so you need to pick just one ""primary"" axis to organize your accounts by." depends entirely on the scope and where your chokepoints are.   if its a question of ginormeous amounts of data being stored in your spreadsheet and then extracted/joined with a mess of index match functions, that can quickly run up in size, and can be deftly replaced with a powerquery setup.   If it's a computation that requires a few iterative steps or complex nested lookups, but with simple inputs, then a few simply scripted UDFs can lower the complexity (and workload and size) of the workbook.   OP also mentions that the workbook is used for the display. If there is a lot of repeated deletion and adding of formats, sometimes workbook size can be seriously affected by these things cluttering up the sheet, and it can be useful to just clear those outs.   I'd say it makes sense to move away from workbooks and into something more technical if you the organizational support to do so. If one person sits and codes models in python but none of his colleagues can work on it or fix it, and it's not documented correctly, and there's no support structure, then I'd be cautious of transferring something business critical to that structure, rather than optimizing the solution that people are familiar with and can modify themselves.   But if it's a tech-savvy organization that recruits accordingly and has the technical support structures to implement changes and modifications as required by the business, I don't see any problem in using other tools. He has included this on Schedule D line 1a, but I don't see any   details on the actual transaction. It is reported on form 8949. However, if it is fully reported in 1099-B (with cost basis), then you don't have to actually detail every position. Turbotax asked me to fill in individual stock sales with proceeds and cost basis information. ... Again, it seems to be documented on Schedule D in boxes 1a and 8a. See above. I received a 1099-Q for a 529 distribution for a family member. It was   used for qualified expenses, so should not be taxable. Then there's nothing to report. I believe I paid the correct amounts based on my (possibly flawed) understanding of estimated taxes. His initial draft had me paying a penalty. I explained my situation for the year, and his next draft had the   penalties removed, with no documentation or explanation. IRS assesses the penalty. If you volunteer to pay the penalty, you can calculate it yourself and pay with the taxes due. Otherwise - leave it to the IRS to calculate and assess the penalty they deem right and send you a bill. You can then argue with the IRS about that assessment. Many times they don't even bother, if the amounts are small, so I'd suggest going with what the CPA did. "There are some assumptions which can be made in terms of the flexibility you have - I will start with the least flexible assumption and then move to more flexible assumptions. If you must put down a number 1, your go-to for this(""Change the start period to 1""), is pretty good, and it's used frequently for other divide-by-zero calculations like kda in a video game. The problem I have with '1' is that it doesn't allow you to handle various scales.  Some problems are dealt with in thousands, some in fractions, and some in hundreds of millions. Therefore, you should change the start period to the smallest significantly measurable number you could reasonably have. Here, that would take your example 0 and 896 and give you an increase of 89,500%. It's not a great result, but it's the best you can hope for if you have to put down a number,  and it allows you to keep some of the ""meaning in the change."" If you absolutely must put something This is the assumption that most answers have taken - you can put down a symbol, a number with a notation, empty space, etc, but there is going to be a label somewhere called 'Growth' that will exist. I generally agree with what I've seen, particularly the answers from Benjamin Cuninghma and Nath. For the sake of preservation - those answers can be summarized as putting 'N/A' or '-', possibly with a footnote and asterisk. If you can avoid the measurement entirely The root of your question is ""What do my manager and investors expect to see?"" I think it's valuable to dig even further to ""What do my manager and investors really want to know?"". They want to know the state of their investment. Growth is often a good measurement of that state, but in cases where you are starting from zero or negative, it just doesn't tell you the right information. In these situations, you should avoid % growth, and instead talk in absolute terms which mention the time frame or starting state. For example:" "The OP does not explain ""what we pay for processing the transaction (cost of debiting the customer)"".  Who exactly do you pay?  Someone else, or your own employees/contractors?  I will assume that $0.10 is paid to your own employees. Dr $10cash from money people give you Cr $10 liability to them because it is their money in your accounts. Dr $0.10 cash payment of paycheques or supplier invoices Cr $0.10 income statement Operating Eexpense  Dr 0.20 liability to depositors for fees they pay, resulting in $9.80 remaining liability for their money you still have. Cr 0.20 income statement Fee Revenues" "You don't. No one uses vanilla double entry accounting software for ""Held-For-Trading Security"".  Your broker or trading software is responsible for providing month-end statement of changes.  You use ""Mark To Market"" valuation at the end of each month.  For example, if your cash position is -$5000 and stock position is +$10000, all you do is write-up/down the account value to $5000.  There should be no sub-accounts for your ""Investment"" account in GNUCash.  So at the end of the month, there would be the following entries:" "An accounting general ledger is based on tracking your actual assets, liabilities, expenses, and income, and Gnucash is first and foremost a general ledger program. While it has some simple ""budgeting"" capabilities, they're primarily based around reporting how close your actual expenses were to a planned budget, not around forecasting eventual cash flow or ""saving"" a portion of assets for particular purposes. I think the closest concept to what you're trying to do is that you want to take your ""real"" Checking account, and segment it into portions. You could use something like this as an Account Hierarchy: The total in the ""Checking Account"" parent represents your actual amount of money that you might reconcile with your bank, but you have it allocated in your accounting in various ways. You may have deposits usually go into the ""Available funds"" subaccount, but when you want to save some money you transfer from that into a Savings subaccount. You could include that transfer as an additional split when you buy something, such as transferring $50 from Assets:Checking Account:Available Funds sending $45 to Expenses:Groceries and $5 to Assets:Checking Account:Long-term Savings. This can make it a little more annoying to reconcile your accounts (you need to use the ""Include Subaccounts"" checkbox), and I'm not sure how well it'd work if you ever imported transaction files from your bank. Another option may be to track your budgeting (which answers ""How much am I allowed to spend on X right now?"") separately from your accounting (which only answers ""How much have I spent on X in the past?"" and ""How much do I own right now?""), using a different application or spreadsheet. Using Gnucash to track ""budget envelopes"" is kind of twisting it in a way it's not really designed for, though it may work well enough for what you're looking for." I'm responsible for all our hedging.  Since we sell the energy to end users we do mostly fixed buys, swaps and calls.  I'm a excel guru and dabble a little in SQL.  we have Crystal Ball as well but i have no idea how to use it.  I guess I'm trying to figure out if there is a tool that people use to help me analyze the spreads. or perhaps some reading material to help me through this. This is what i've been working towards for so long and i really don't want to fuck this up "This may be closed as not quite PF, but really ""startup"" as it's a business question.  In general, you should talk to a professional if you have this type of question, specifics like this regarding your tax code. I would expect that as a business, you will use a proper paper trail to show that money, say 1000 units of currency, came in and 900 went out. This is a service, no goods involved. The transaction nets you 100, and you track all of this. In the end you have the gross profit, and then business expenses. The gross amount, 1000, should not be the amount taxed, only the final profit." "Because you've sold something you've received cash (or at least an entry on your brokerage statement to say you've got cash) so you should record that as a credit in your brokerage account in GnuCash. The other side of the entry should go into another account that you create called something like ""Open Positions"" and is usually marked as a Liability account type (if you need to mark it as such). If you want to keep an accurate daily tally of your net worth you can add a new entry to your Open Positions account and offset that against Income which will be either negative or positive depending on how the position has moved for/against you. You can also do this at a lower frequency or not at all and just put an entry in when your position closes out because you bought it back or it expired or it was exercised. My preferred method is to have a single entry in the Open Positions account with an arbitrary date near when I expect it to be closed and each time I edit that value (daily or weekly) so I only have the initial entry and the current adjust to look at which reduces the number of entries and confusion if there are too many." "Since this is a cooperative I'm guessing your partners may want to be able to view the books so another key point you may want to consider is collaboration.  QuickBooks desktop has all of these same issues because it is meant to be used on a single desktop. We're in an age of mobile devices, and especially in a business like landscaping it would be nice if certain aspects of record keeping could be done at the point and time where they are incurred.  I'd argue you want a Software as a Service (SaaS) accounting package as opposed to ""accounting software"" which might come on a CD in the form of QuickBooks, Sage and others. Additionally, most of these will also have guides to help make sure you are properly entering your records. Most of these SaaS products also have customer success teams to help you along should you need assistance. Depending on the level of your subscription you may get more sophisticated handling of taxes, customized invoices or integrated payroll. Your goal is to keep accurate records so you can better run your business and maintain obligations like filing taxes. You're not keeping the records just to have them. Keep them in a place where they will work for you and provide the insights and functionality that will help your business grow and become successful. Accounting software will always win in this scenario over a spreadsheet. FULL DISCLAIMER: I work for Kashoo, a simple cloud accounting product designed for small businesses. But the points I mention above are true for Xero, QuickBooks Online and Wave as well as Kashoo. And if you really want expertise to go with the actual software consider service providers with a platform like: Indinero, Bench, easyrecordbooks or Liberty Accounting." Typically that applies if the broker Form 1099-B reports an incorrect basis to the IRS.  If the Form 1099-B shows incorrect basis relative to your records, then you can use 8949, column (g) to report the correct basis.  The 8949 Instructions provide a brief example. http://www.irs.gov/pub/irs-prior/i8949--2013.pdf Although you have an obligation to report all income, and hence to report the true basis, as a practical matter this information will usually be correct as presented by the broker.  If you have separate information or reports relating to your investments, and you are so inclined, then you can double-check the basis information in your 1099-B. If you aren't aware of basis discrepancies, then the adjustments probably don't apply to you and your investments can stick to Schedule D. Funds earned and spent before opening a dedicated business account should be classified according to their origination. For example, if your business received income, where did that money go?  If you took the money personally, it would be considered either a 'distribution' or a 'loan' to you.  It is up to you which of the two options you choose. On the flip side, if your business had an expense that you paid personally, that would be considered either a 'contribution of capital' or a 'loan' from you. If you choose to record these transactions as loans, you can offset them together, so you don't need two separate accounts, loan to you and loan from you. When the bank account was opened, the initial deposit came from where?  If it came from your personal funds, then it is either a 'contribution of capital' or a 'loan' from you. From the sound of your question, you deposited what remained after the preceding income/expenses.  This would, in effect, return the 'loan' account back to zero, if choosing that route. The above would also be how to record any expenses you may pay personally for the business (if any) in the future. Because these transactions were not through a dedicated business bank account, you can't record them in Quickbooks as checks and deposits.  Instead, you can use Journal Entries.  For any income received, you would debit your capital/loan account and credit your income account.  For any expenses, you would debit the appropriate expense account and credit your distribution/loan account. Also, if setting up a loan account, you should choose either Current Asset or Current Liability type.  The capital contribution and distribution account should be Equity type. Hope this helps! I suggest that you use your own judgement on this. You can assign a reasonable percentage since it is impossible to monitor the hours using those assets. Example: 40 personal and 60 for business. It's really your call. I also suggest that you should be conservative on valuing the assets. Record the assets at it's lowest value. This is one of the most difficult scenarios in making your own financial statements. You can also use this approach, i will record the assets at its original cost then use a higher depreciation rate or double declining method of depreciation. If the assets have a depreciation rate of 20% per year (useful life of 5 years), i will make it 30%. the other 10% will add more expense and helps you not to overstate your Financial Statement. You can also use the residual value of the asset, but if you do this, you should figure out the reliable amount. I understand that this is not for tax reporting purposes. Therefore, there's no harm if you overstate your Financial statement. And even if you overstate, you can still adjust the cost of the asset. Along the way (in the middle of the year or year end), you will figure out the cost of the asset if it's over valued once the financial statement is done. "There is no ""standard"" way for personal accounting.  However, GNUCash default accounts set includes ""Expense: Adjustment"".  It is usually used by the community for reconciliation of unknown small money lost."