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
I'm not an expert in the field, but I'm pretty sure they *do*, its just that the customers arent us, but rather the landlords/cc companies/car dealerships/etc. who pay them for credit checks. Those parties do choose to do business with them and have alternatives. CreditKarma review I don't personally use HelloWallet, but I have also heard very good things about it. Independence from financial products is a HUGE thing in the field because so many investment advisers place the firm before the customer (c.f. Too Big To Fail), so having an independent resource is a huge benefit. "I recently needed to compute a better balance that let us pick and choose what to include in the computed sum without losing information, so I revisited this topic and I'm pleased to say that I've found a solution that works (at least for our data - you may have transactions that this code doesn't recognize, but you can always modify it to match). My solution was written natively for MS SQL Server 2008 or later, it uses a scalar UDF, a VIEW, and a windowed aggregate (SUM OVER (ORDER BY ...) which means it should be almost-syntax compatible with PostgreSQL. MySQL does not support OVER but you can perform a running-sum using a variable with arithmetic addition directly in the SELECT clause. Create a database table with this schema (feel free to exclude columns you're not interested in, such as Option1Name): Create a UNIQUE index on TxnId - you could use it as a primary-key, I suppose. You might be tempted to create a Foreign-Key relationship between ReferenceTxnId and TxnId, however this will fail if you enforce it: we have many transactions where ReferenceTxnId points to a Transaction that doesn't exist. This is usually in the case of [Type] = 'Web Accept Payment Received' AND [Status] = 'Canceled'. We also have some TransactionId values longer than 17 characters: some TransactionIds start with ""U-"" - all pending money requests, I suspect this indicates the transaction is ""unfinished"". Re-download your entire PayPal History CSV files so that you have the latest retroactive updates. Import these CSV files into this PayPalHistory table. Do a simple test to see how bad PayPal's default data is: To find out where the differences are coming from, run this query: (The ORDER BY (...), RowId is to ensure consistent ordering when multiple transactions share the same timestamp) As you scroll through the results, you'll see how the naive SUM is thrown-off from the official PayPal-computed Balance column. So as you can see, the Net column value cannot always be trusted - what we need is to generate our own ""EffectiveNet"" value which is accurate - that is, the value is 0.00 for rows which do not affect the balance, instead of being what they are right now. The problem is, given a single row of data (such as any single row from the example table in my original Question) we have no way of inherently knowing what its ""EffectiveNet"" is. I have devised two functions to help solve this problem, the first function only looks at the ReferenceTxnId, Type and Status column values and generates accurate values for the vast majority of rows - indeed, in our dataset we only had one row for which this approach did not work. I recommend you try this one first and compare the running-sum value to ensure it works for your data: You can use this function in the query like so below, hopefully it should give you an accurate running-sum and balance figure at the end: 8. And here's the view that ties it all together: Used like so: I hope this helps anyone else wanting to do accurate bookkeeping with PayPal Transaction History files!" I just found this old post. I worked in this field 4 years ago. The information is old. I assume the players are mostly the same.  AIR in Boston and EQE in Oakland do the computer modeling for cat bonds and reinsurance. Hedge funds will often hire guys who have worked with the software.  Swiss Re is the investment bank for cat bonds.   The hedge funds that do cat bonds exclusively are pretty boutiquey. The exception is DE Shaw.  Reinsurance is a pretty good entry into cat bonds.  just some thoughts. get back to me if you have more questions. I found a way to do this, but it's slightly backwards. Quicken does not allow you to make a graph of just your income, probably because that would be a fairly boring graph for most people.  But it does allow you to do a graph of your expenses.  Doing so, while including income categories, will produce the graph I want, but with negative numbers (savings is negative spending). This will show a bar graph of overall spending, counting income as Negative Spending.  So, having negative bars is good in this case. Have you looked into GnuCash? It lets you track your stock purchases, and grabs price updates. It's designed for double-entry accounting, but I think it could fit your use case. You decide on a cost bases attribution yourself, per transaction (except for averaging for mutual funds, which if I remember correctly applies to all the positions). It is not a decision your broker makes. Broker only needs to know what you've decided to report it to the IRS on 1099, but if the broker reported wrong basis (because you didn't update your account settings properly, or for whatever else reason) you can always correct it on form 8949 (columns f/g). "I don't know if this is ""valid"" from a bookkeeping/accounting standpoint, but I'm just trying to keep records for myself so this works for me unless someone has another suggestion. I created two Expense accounts for the HSA (Roth, etc would work the same way): (""CY"" meaning current year.) When I make a $50 contribution, I enter the following splits: When you look at this in the Accounts tab, it shows the parent account with a zero balance (because the subaccount balance is positive and the parent account is negative). The subaccount has the balance accumulated so far; this lets me see the YTD contributions to my HSAs. At the end of the year I will make a closing transaction in the opposite direction (for whatever the total balance of the CY account is): This will zero-balance these two accounts. The only complication I see remaining is the issue of making contributions for the prior year during the January-April time frame. I don't generally make current-year contributions followed by prior-year contributions, so I can just wait to enter the closing transaction until I know I'm done with prior-year contributions."