Correct Ways of Importing Personal Finance Transaction Data
You'll need to find out in what format MoneyStrands expects the data.  A .qif or an .ofx file may not be the answer.
I'm using iBank on my Mac here and that definitely supports different currencies and is also supposed to be able to track investments (I haven't used it to track investments yet, hence the 'supposed to' caveat). "Yodlee and Mint are good solutions if you don't mind your personal financial information being stored ""in the cloud"". I do, so I use Quicken. Quicken stores whatever you give to it for as long as you want: so the only question is how to get the credit card transactions you want into it? All my financial institutions allow me to view my credit card statements for a year back, and download them in a form Quicken can read. So you can have a record of your transactions from a year ago right now, and in a year you will have two year's worth." Assuming you have registered your activities as partnership and receiving this money as Individual, you need to show this under Schedule OS, 1d [other income]. this will be under the ITR-2 [tab CG-OS] XLS tax preparation utility given by Tax Department. The XLS can be found at https://incometaxindiaefiling.gov.in/portal/individual_huf.do If the funds you are receiving are large [more than say Rs 500,000] then suggest you incorporate a partnership firm or company, there are quite a few exceptions you can claim lowering you tax outgo.  The fact that you are transferring funds to your partners can be an issue incase you get audited. You would need to have sufficient evidence to show that the money paid was for services rendered directly and not your income. It would be easier if you create a partnership or have the client directly pay to them. Again if the sum is small its fine, as the sum becomes large, it would get noticed by the tax authorities. I use MoneyStrands (formerly called Expensr), but mostly just to track expenses and look at reports on my spending habits. It has some really pretty charts, with the ability to drill down into categories and sub-categories, or graph monthly spending for any custom date range. It does a half-decent job of auto-categorizing the imported bank transactions, and you can set up additional rules for common vendors, but I still have to do some manual work after each import. It does a good job of integrating my credit cards, bank accounts, and I can even manually add cash transactions. It has some basic budgeting capabilities, but they're not very useful for someone who needs to carefully budget thier monthly spending. Another one I've heard about is mint.com, but it only supports American banks (last I heard, anyway). "The solution I've come up with is to keep income in CAD, and Accounts Receivable in USD.  Every time I post an invoice it prompts for the exchange rate. I don't know if this is ""correct"" but it seems to be preserving all of the information about the transactions and it makes sense to me.  I'm a programmer, not an accountant though so I'd still appreciate an answer from someone more familiar with this topic." You can take a shortcut and make a few cumulative transactions, maybe just estimate how much of your spending landed in each of your budget categories, but you will lose a lot of the value that you were building for yourself by tracking your spending during the earlier months. I reconcile my budget and categorize my spending on a monthly basis. It's always a chore to pull out the big stack of receipts and plow through them, but I've learned the value of having an accurate picture of where all my money went. There is no clean way to fake it. You can either take the time and reconcile your spending, or you can take a short cut. It probably renders your efforts to track everything from the beginning of the year invalid though. If you want to start over this month (as you did at the beginning of the year) that would probably be a cleaner way to reconcile things. Yup. What I wanted to know was where they are pulling it up from. Have casually used Google finance for personal investments, but they suck at corp actions. Not sure if they provide free APIs, but that would probably suck too! :D "Considering the fact that you are so unaware of how to find such data, I find it very very hard to believe that you actually need it. ""All trade and finance data for as much tickers and markets as possible."" Wtf does that even mean. You could be referencing thousands of different types of data for any given ""ticker"" with a statement so vague. What are you looking for?" I generally concur with your sentiments. mint.com has 'hack me' written all over it.  I know of two major open source tools for accounting: GNUCash and LedgerSMB. I use GNUCash, which comes close to meeting your needs: The 2.4 series introduced SQL DB support; mysql, postgres and sqlite are all supported. I migrated to sqlite to see how the schema looked and ran, the conclusion was that it runs fine but writing direct sql queries is probably beyond me. I may move it to postgres in the future, just so I can write some decent reports. Note that while it uses HTML for reporting, there is no no web frontend. It still requires a client, and is not multi-user safe. But it's probably about the closest to what you what that still falls under the heading of 'personal finance'. A fork of SQL Ledger, this is postgreSQL only but does have a web frontend. All the open source finance webapps I've found are designed for small to medium busineses. I believe it should meet your needs, though I've never used it. It might be overkill and difficult to use for your limited purposes though. I know one or two people in the regional LUG use LedgerSMB, but I really don't need invoicing and paystubs. 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 would say when starting with Gnucash to start with the level of granularity you are comfortable with while sticking to the double entry bookkeeping practices. So going through each one: Refund for Parking Pass. Assuming you treat the Parking Pass as a sunk cost, i.e. an Expense account, its just a negative entry in the Expense account which turns into a positive one in your Bank account. Yes it may look weird, and if you don't like it you can always 'pay from Equity' the prior month, or your Bank Account if you're backfilling old statements. Selling physical items. If you sold it on eBay and the value is high enough you'll get tax forms indicating you've earned x. Even if its small or not done via eBay, treat it the same way and create a 'Personal Items/Goods' Income account to track all of it. So the money you get in your Bank account would have come from there. Found jacket money would be an Equity entry, either Opening Balances into Cash or Bank account. Remember you are treating Equity / Opening Balances as the state before you started recording every transaction so both the value going into Assets (Banks,Stock,Mutual Funds) and Liabilities (Mortgage, Student Debt, Credit Card Debt) originate from there. "That's Imbalance-USD (or whatever your default currency is). This is the default ""uncategorized"" account. My question is, is it possible to get the ""unbalanced"" account to zero and eliminate it? Yes, it's possible to get this down to zero, and in fact desirable. Any transactions in there should be reviewed and fixed. You can delete it once you've emptied it, but it will be recreated the next time an unbalanced transaction is entered. Ideally, I figure it should autohide unless there's something in it, but it's a minor annoyance. Presumably you've imported a lot of data into what's known as a transaction account like checking, and it's all going to Imbalance, because it's double entry and it has to go somewhere. Open up the checking account and you'll see they're all going to Imbalance. You'll need to start creating expense, liability and income accounts to direct these into.  Once you've got your history all classified, data entry will be easier. Autocomplete will suggest transactions, and online transaction pull will try to guess which account a given transaction should match with based on that data." "These sort of issues in structuring your personal finances relative to expenses can get complicated quickly, as your example demonstrates.  I would recommend a solution that reduces duplication as much as possible- and depending on what information you're interested in tracking you could set it up in very different ways. One solution would be to create virtual sub accounts of your assets, and to record the source of money rather than the destination.  Thus, when you do an expense report, you can limit on the ""his"" or ""hers"" asset accounts, and see only the expenses which pertain to those accounts (likewise for liabilities/credit cards). If, on the other hand, you're more interested in a running sum of expenses- rather than create ""Me"" and ""Spouse"" accounts at every leaf of the expense tree, it would make much more sense to create top level accounts for Expenses:His:etc and Expenses:Hers:etc.  Using this model, you could create only the sub expense accounts that apply for each of your spending (with matching account structures for common accounts)." Use one journal entry, and split the expenses into the appropriate accounts. This can happen even if you never mix business and personal on the same receipt: say you order office supplies (which where I live are immediately deductible as an expense) and software or hardware (which must be depreciated because they are assets) on the same order. We have an account called Proprietors Loan which represents money the company is lending to the humans who own it, or that the humans are lending to the company. Were I to pay for my personal lunch on a business credit card, it would go through that account, increasing the amount the company has lent me or decreasing the amount I have lent it. Similarly if I made a business purchase with a personal card it would go through that account in the other direction. Where I live, I can lend my company all the money I want any time, but if the company lends me money there can't be an outstanding balance over the corporate year end. If you make two credit card entries of 5 and 10 when you go to reconcile your accounts it will be harder because you'll have to realize they together match the single 15 line on your statement. Making a single entry (your A option) will make reconciling your statement much easier. And that way, you'll probably reconcile your statements, which is vital to knowing you actually recorded everything. "I found your post while searching for this same exact problem. Found the answer on a different forum about a different topic, but what you want is a Cash Flow report.  Go to Reports>Income & Expenses>Cash Flow - then in Options, select the asset accounts you'd like to run the report for (""Calle's Checking"" or whatever) and the time period. It will show you a list of all the accounts (expense and others) with transactions effecting that asset. You can probably refine this further to show only expenses, but I found it useful to have all of it listed.  Not the prettiest report, but it'll get your there."