query: US citizen transferring money to Indian fiance to buy property

positive: A. Kindly avoid taking dollars in form of cash to india unless and until it is an emergency. Once the dollar value is in excess of $10,000, you need to declare the same with Indian customs at the destination. Even though it is not a cumbersome procedure, why unnecessarily undergo all sort of documentation and most importantly at all security checks, you will be asked questions on dollars and you need to keep answering.   Finally safety issue is always there during the journey.  B.There is no Tax on the amount you declare. You can bring in any amount. All you need is to declare the same.  C. It is always better to do a wire transfer.  D. Any transfer in excess of $14,000 from US, will atract gift tax as per IRS guidelines. You need to declare the same while filing your Income Tax in US and pay the gift tax accordingly.  E. Once your fiance receives the money , any amount in excess of Rs 50,000 would be treated as individual income and he has to show the same under Income from other sources while filing the taxes. Taxes will be as per the slab he falls under.  F.Only for blood relatives , this limit of 50,000 does not apply.  G. Reg the Loan option, suggest do not opt for the same. Incase you want to go ahead, then pl ensure that you fully comply with IRS rules on Loans made to a foreign person from a US citizen or resident. The person lending the money must report the interest payment as income on his or her yearly tax return provided the loan has interest element. No deduction is allowed if the proceeds are used for personal or non-business purposes.In the case of no-interest loans, most people believe there is no taxable income because no interest is paid.  The IRS views this seriously and the tax rules are astonishingly complex  when it comes to no-interest loans.  Even though no interest is paid to the lender, the IRS will treat the transaction as if the borrower paid interest at the applicable federal rate to the lender and the lender subsequently gifted the interest back to the borrower.The lender is taxed on the imaginary interest income and, depending on the amount, may also be liable for gift tax on the imaginary payment made back to the borrower. Hope the above claryfies your query. Since this involves taxation suggest you take an opinion from a Tax attorney and also ask your fiance to consult a Charted Accountant on the same. Regards

negative: You cannot directly transfer money from your Bank Account.   You can use Debit Card to make payments to your paypal account. Just enter the details of the payment and amount, it would make the necessary deduction from your debit card.   Indian regulations do not allow you to store value in your paypal account. This credits have to be transfered to a Bank account.

negative: Depending on how tech savvy your client is you could potentially use bitcoin. There is some take of indian regulators stopping bitcoin exchanges, meaning it might be hard to get your money out in your local country but the lack of fees to transfer and not getting killed on the exchange rate every time has a huge impact, especially if your individual transaction sizes are not huge.

negative: Well... they could force first time, overseas buyers who aren't citizens or even permanent residents to buy property in the regions or other economically depressed areas.  Look, these people are buying property for two reasons:  1 - boltholers (simply looking for a place to land that will offer them alternative citizenship/residency when cultural revolution 2.0 finally happens or simply looking for somewhere that isn't lung chokingly polluted).  2 - rent seekers (don't trust the two money, internal external, Yuan/Renminbi system to hold value and are seeking something that generates revenue denominated in a current not controlled by the One Party One China system that is outside of the state run banking system).

negative: You could use the money to buy a couple of other (smaller) properties. Part of the rent of these properties would be used to cover the mortgage and the rest is income.

negative: Can I bring a bankers cheque or DD from singapore bank . Yes you can.  Remember if they are payable in Singapore, i.e. SGD denominated, they will take time to clear; typically around a month. Alternatively you can approach an Indian Bank in Singapore they can arrange for a Rupee draft payable in city of your choice. The Banks also have a facility of opening an NRE account in the city/Branch of your choice by opening account with wire transfer.  I do not have time for NRE account Money can be transferred into your NRO account as well. You could also use remittance services that provide better exchange rates.

negative: http://dealbook.nytimes.com/2014/12/13/small-bank-in-kansas-is-a-financial-testing-ground/ Citizens Bank of Weir might allow you to do this, their experimentation in speeding up bank transfers was pushing money over the debit card network.

negative: Yes, you can keep the accounts.  In fact, I opened my US bank account as a Canadian citizen living in Canada, and still have it after living in the US and returning. American Express offers UK cards and the have an excellent system for transferring the cards.  You should definitely contact them about this, otherwise you will likely have to start building credit from scratch in the UK.  AE Global Card Transfer

negative: The interest on a loan secured by a rental property is not deductible at all. The interest on a loan used to buy (or improve) the rental property is deductible, regardless of where you got it from (you can take money from your credit card to buy a rental - it will be deductible). The deductability is per the use of the money, not the source, with the cash-out up to 100K from your primary residence being the notable exception.

negative: It's important to note that the US is also the country that taxes its expats when they live abroad, and forces foreign banks to disclose assets of US citizens.  Americans are literally the property of their government. America is a tax farm and its citizens can't leave the farm. Wherever you go, you are owned.  And that now appears to be true of your Bitcoin as well. Even if you spend 50 years outside the USA, your masters want a piece of what you earn.  Land of the Free.

negative: Citation? Please go looking for yourself, it should be easy for a curious mind to do.  How many jobs were lost to just china?  In rochester, ny alone, kodak has big investments and production moved to china.    Now, take xerox they are outsourcing jobs to india.  software and engineering, you get transfered and go work for the indian company or cya.  Look at Delphi, they are in Juarez mexico big time.  Search out the trade $, we trade large w/ these countries and more.  I don't mind trading but it should be balanced.  So much of them buying here and so much us buying there.  There are certain sectors of higher paying manufacturing jobs that are gone to not just to china but also mexico and india.  What jobs replaced them?    Of greater concern should be the stagnant wages of the last 30 years.

negative: You could buy a money order with your cash, then mail the money order to Deutsche Bank Germany for deposit into your account. You could also buy a prepaid debit card (like a Visa/AMEX giftcard) with your cash. Then, open a new Paypal account and add this prepaid card. Finally, send money to yourself using the prepaid card as the funding source. You could use a money transfer service, like Western Union, to transfer the cash to a friend/family in Germany. Then ask them to deposit it for you at Deutsche Bank Germany.

negative: "This depends on the country(ies) involved. US citizen/resident giving gifts is required to pay a gift tax. The recipient of the gift, however, pays nothing. The value of the gift at the time of the gift-giving is used to determine the tax, and an exclusion of $14000 per person per year (as of 2013) is available to allow smaller gifts to be given without too much of a red tape. There's also a lifetime exemption which is shared between the gift tax and the estate tax. This exemption is $5.25M in 2013.  The reason the gift tax exists in the US is because the US tax code is very aggressive. This is basically double taxation, similarly to estate tax. Gifts/estates are after-tax money, i.e.: income tax has been paid on them, yet the government taxes them again. Why? The excuse is to disallow shifting of income: if one person has high income tax brackets, he may give some of his income-producing property to another person with lesser brackets who would then pay less income taxes (for example, parents would transfer property to children). Similarly capital gains could be shifted. Generation-skipping tax is yet another complication to disallow people use gifts to avoid estate taxes: a grandparent would gift stuff to grandchildren, thus skipping a level of estate taxes (the parents in between). In other countries the tax codes may be less aggressive, and not tax gifts/inheritance as this money has been taxed before. This is a more fair situation, IMHO, yet it means that wealth moves from generation to generation without the ""general public"" benefiting from it. So if you're a US person and considering giving or receiving a gift - you need to consult with a tax adviser about the consequences. Similarly with other countries, if you are subject to their tax laws."

negative: "As others have mentioned, it's important that there is a fair assessment of the market value of the items being donated.  Joel's point about the government not looking kindly upon overvalued donations also applies in Canada: the CRA doesn't look kindly upon donation schemes such as ""buy-low, donate-high arrangements."" Since nobody has offered up authoritative information for Canada yet, here's something to look at: Excerpts: 3) Gifts in kind of a taxpayer   include capital property, depreciable   property, personal-use property ... [...]   6) The fair market value of a gift in   kind as of the date of the donation   (the date on which beneficial   ownership is transferred from the   donor to the donee) must be determined   before an amount can be recorded on a   receipt for tax purposes. [...]  The   person who determines the fair market   value of the property must be   competent and qualified to evaluate   the particular property being   transferred by way of a gift. Property   of little or only nominal value to the   donor will not qualify as a gift in   kind. Used clothing of little value   would be an example of a   non-qualifying contribution. You will need to find a charity that would both value the books you would be donating and be willing to issue you a receipt for your charitable donation.  Whatever receipt they issue should be in line with fair market value of the goods donated.  Assume your donation receipt will be challenged, and keep both: Finally, reasonable comparables might be prices for similar used goods, not a percentage of new.  Though, if you can't find a price for a particular title in the used market, an estimate consistent with other valuations in the lot would be better than nothing, perhaps."

negative: It's technically correct to say BK will still pay taxes on all profits made here in the US, the problem here is that it's very easy to structure this whole thing so that there are no US profits.   Company A sells itself to Company B, which it also owns. Company A transfers all its' intellectual property to Company B which then charges Company A a fee to use it. The fee is structured so that Company A makes zero profit and Company B makes all the money.

negative: Would I have to pay income tax other then TDS on interest earned on my saving bank account. No being NRI you are not taxed in India on income outside of India. I am sending money from EU to my OWN saving account. Please note this account is not NRI\NRO\FCNR As an NRI you CANNOT by law hold a regular Savings Account. Please convert this account to NRO ASAP. Does the channel I use to transfer money to India would make any difference? Its 3rd party transfer service. Whether you transfer the funds or not is irrelevant. As the income was during the period when your status is NRI, there is no Tax in India. sold some shares from my Indian demat account online and got some STCG. You would need to pay tax on this in India Edit:   Self Assessment Tax can be paid till 30 July 2015 for the Financial Year 1 April 2014 to 31 March 2015. Tax have to be paid in advance, so if your tax obligation is more than Rs 10,000/- there will be an interest at 1% per month and penalty at 1% per month payable

negative: Another answer to this question occurred to me as I started learning more about historical uses for gold etc.  Perhaps it's a crackpot idea, but I'm going to float it anyway to see what you folks think. Investing in Gold is an indirect investment in the Economy and GDP of the nation of India.  To that extent is it only a hedge against inflation, so long as the indian economy grows at a more rapid rate than your local inflation rate.  Fact, India currently consumes more than 1/3 of gold production, predominantly in the form of Jewelry. And their demand has been growing rapidly, up 69% just between 2009 and 2010 alone. I can't find too many historial consumption numbers for India, but when you look at past articles on this subject, you see phrases like 'one forth' and '20%' being used only a few years go to describe India's consumption levels. Fact, India has virtually no domestic sources of gold.  India’s handful of gold mines produce about 2.5 tonnes of the metal each year, a fraction of the country’s annual consumption of about 800 tonnes. Fact. Indian Culture places high value on gold as a visible demonstration of wealth.  Particularly in situations such In Indian weddings where the bride brings in gold to show her family's status and wealth and it forms part of the dowry given to bride. It is believed that a bride wearing 24k gold on their wedding to bring luck and happiness throughout the married life. Fact, the recent trends in outsourcing, Indian citizens working abroad sending money home, etc have all lead to a influx of foreign cash to the Indian economy and explosive GDP growth. See the following chart and compare the period of 2000-current with a chart showing the price of gold in other answer here.  Notice how the curves parallel each other to a large degree  Potentially unfounded conclusion drawn from above numbers.  The rapid growth of the Indian economy, coupled with a rich cultural tradition that values gold as a symbol of wealth, along with a sudden rise in 'wealthy' people due to the economy and influx of foreign cash, has resulted in skyrocketing demand for gold from India, and this large 'consumption' demand is the most likely explanation for the sudden rise in the price of gold over the last several years.  Investors then jump on the 'rising price bandwagon' as especially does anyone that can make a profit from selling gold to those seeking to get on said bandwagon. As such, as long as indian cultural tradition remains unchanged, and their economy remains strong, the resulting increasing demand for gold will sustain current and perhaps increased prices.  Should there be any sudden collapse in the Indian GDP, gold will likely tumble in parallel. disclaimer: not an expert, just observations based off the data I've seen, there may be other parts to the picture of 'gold demand' that I've not considered.

negative: GelomanIndianSpares is one of complete motorcycle spare parts resources for motorcycle enthusiasts. On our company website are available Indian motorcycle spare parts catalogs along with thousands of more parts. People who want to continue riding their Indian motorcycles should always try to buy the correct spare parts. You could also contact us anytime about all motorcycle spare parts and talk with our professional. We will very happy to help you with your queries.

negative: One other consideration. If you are a US citizen or Resident Alien, you are going to owe US income taxes regardless of where you earn the money. Here it is straight from the horse's mouth: Tax guide for US Citizens living abroad

negative: There are tax strategies you could take advantage of if you own the property. Find local real estate investors that like 'buy and hold'. Additional strategy is to buy a property and sell it with owner financing (you use a Residential Mortgage Loan Officer to facilitate.) What is great is you can get a great % real return on your money without being a landlord.

negative: The Indian lawyer areas are commercial and investment laws, corporate law and intellectual property laws. You can seek online legal dispute resolution without personally approaching any arbitrator or mediator. This is the most economical way of resolving disputes in minimum possible time.

negative: Basically there are 2 ways you can make money from an investment, through income (eg: rent or dividends) and through the price of the investment going up (capital growth or gains). Most people associate negative gearing with investment properties but it can be done with shares and other investments where you borrow money to buy the investment and it produces an income of some sort. If the investment does not produce an income then you cannot negative gear it. Using a property as an example (in Australia), if all your expenses each month (loan interest payments, council and water rates, insurance and/or strata, advertising and management fees, depreciation, and maintenance expense) are greater than your income (rent), then you are negative gearing the investment property. This is a monthly loss on your investment which can be used to offset and reduce the amount of tax you pay during the year. So most people negative gearing an investment property will get a nice sum back when they do their tax returns. The problem with negative gearing is that you have to lose money in order to save some tax. So as an example, if you are on a marginal tax rate of 30%, for every $1 you lose from the investment property you will save 30c in tax. If your marginal tax rate is 45% then will save 45c in tax for every $1 lost on the investment property. Thus negative gearing becomes more tax effective the higher your income (and tax bracket). But you are still losing money overall. The problem is that most novice investors buy an investment property for the main purpose of reducing their taxes. This can be dangerous because the main reason to buy any investment should be that you consider it to be a good investment, not to save you tax. Because if the investment is not a good one, then you will not only lose money on the income side but also on the capital side. Negative gearing should be looked at as a bonus or additional benefit when chosing a good investment to buy, not as the reason to buy the investment.

negative: Some motorcycle owner uses these spare parts to take motorcycle racing performance. If you have to buy Antique Indian motorcycle you with better to know that online traders will usually provide both new and used motorcycles. We provide all Indian motorcycle spare parts online.You can rely on our motorcycle spare parts and we have served many clients with a complete satisfaction and now we have become the leader in the industry.

negative: In case the other ATM is visa enabled, many bank allows transfer to visa card through their ATM. More details about your banks are required for a very specific answer. I suppose both banks are Indian Bank, which bank ?

negative: "It is not a ""better world"" when all we've done is trade one set of victims for another.   There is nothing ""Fair"" about FORCING one citizen to do what the mob thinks they should.  ""Life, liberty, and the pursute of happiness and all that"" does not include being able to force other people to do what YOU want with THEIR property.  This is theft by any reasonable definition.  The only civil rights that are ever morally justified are *before the law as a citizen*.  Your government should treat all its citizens equally.  There is no sense in which this ought to translate to the private sector except under voluntary conditions, not by the state shoving a gun in your ear and forcing you to do so."

negative: From what I hear, usually not.  Get an amortization schedule for the property, and see what the savings on the interest rate is.  Then see what the interest versus borrowing less is. The consider that you can invest the buy down money, or better yet use it as down payment and borrow less money.  Typically (as experienced by wife who use to be a loan processor) the buy down did not save any money, and just made the broker a bigger commission.

negative: Assuming you are Resident Indian. As per Indian Income Tax  As per section 208 every person whose estimated tax liability for the year exceeds Rs.   10,000, shall pay his tax in advance in the form of “advance tax”. Thus, any taxpayer   whose estimated tax liability for the year exceeds Rs. 10,000 has to pay his tax in   advance by the due dates prescribed in this regard. However, as per section 207, a   resident senior citizen (i.e., an individual of the age of 60 years or above) not having any income from business or profession is not liable to pay advance tax.   In other words, if a person satisfies the following conditions, he will not be liable to pay advance tax:   Hence only self assessment tax need to be paid without any interest. Refer the full guideline on Income tax website

negative: When property changes hands the sale prices may or may not be used to determine the appraised value of the property, and they may or may not be used to determine the appraised value of other properties. Because of the nature of the transaction: you already have an existing business relationship, the local government is likely to ignore the data point provided by your transaction when determining values of similar properties. They have no idea if there was some other factor used to determine the price. They will also not include in the calculation transactions that are a result of foreclosure becasue the target price is the loan value not the true value.  California and some other jurisdictions do add another wrinkle. You will need to determine if the transaction will trigger a reevaluation of the property value. In some states the existing laws of the state limited the annual growth of the assessment, but that could now be recaptured if the jurisdiction rules that this is a new ownership: California Board of Equalization - Change in Ownership - Frequently Asked Questions How does a change in ownership affect property taxes? Each county assessor's office reviews all recorded deeds for that   county to determine which properties require reappraisal under the   law. The county assessors may also discover changes in ownership   through other means, such as taxpayer self-reporting, field   inspections, review of building permits and newspapers. Once the   county assessor has determined that a change in ownership has   occurred, Proposition 13 requires the county assessor to reassess the   property to its current fair market value as of the date ownership   changed. Since property taxes are based on the assessed value of a property at   the time of acquisition, a current market value that is higher than   the previously assessed Proposition 13 adjusted base year value will   increase the property taxes. Conversely, if the current market value   is lower than the previously assessed Proposition 13 adjusted base   year value, then the property taxes on that property will decrease. Only that portion of the property that changes ownership, however, is   subject to reappraisal. For example, if 50 percent of the property is   transferred, the assessor will reassess only 50 percent of the   property at its current fair market value as of the date of the   transfer, and deduct 50 percent from any existing Proposition 13 base   year value. In most cases, when a person buys a residence, the entire   property undergoes a change in ownership and 100 percent of the   property is reassessed to its current market value.

negative: I don't see how Paypal can stop you from transferring USD funds from your paypal account to a USD account held with a bank. Just tell them to do the transfer to your account. The issue could be around USD onshore / offshore regulation. Is the US government preventing EU citizens from taking USD income offshore? If that's the case then you need a correspondent bank. So in other words, like using your friend. But what you can do is ask your bank who is their correspondent bank in the US, and whether they have the license required to transfer USD funds offshore. So you shift the regulation issues to your bank, and then you have to accept your bank's exchange rate - which is going to be better than paypal, who charges too much for FX transactions.

negative: Simply transferring money you own from overseas to Canada will not mean you need to pay tax on it. However if you sell property at a profit - I.e. sell it for more than you paid for it - you may have to pay tax on any gains. This is true whether or not you transfer the money to Canada. Calculating the amount is quite complicated. You might consider getting a tax expert.

negative: "The main reason people buy dollars (or other currency) on the black market is because they are prevented from exchanging currency on the official government market. Venezuela for example restricts citizens to a maximum number of dollars the citizen can buy or sell per year, depending on various factors such as whether or not the person is studying at a foreign university. If the citizen wants to exchange more dollars than legally allowed, that person must buy or sell at the ""black"" market rate, rather than through the official/government market."

negative: I'm an Aussie and I purchased 5 of these properties from 2008 to 2010. I was looking for positive cash flow on properties for not too much upfront investment. The USA property market made sense because of the high Aussie $$ at the time, the depressed property market in the US and the expensive market here.  I used an investment web-site that allowed me to screen properties by yield and after eliminating outliers, went for the city with the highest consistent yield performance. I settled on Toledo, Ohio as it had the highest yields and was severely impacted by the housing crisis. I bought my first property for $18K US which was a little over $17K AUD.  The property was a duplex in great condition in a reasonable location.  Monthly rentals $US900 and rents guaranteed and direct deposited into my bank account every month by section 8.  Taxes $900 a year and $450 a year for water. Total return around $US8,000.   My second property was a short sale in a reasonable area. The asking was $US8K and was a single family in good condition already tenanted.  I went through the steps with the bank and after a few months, was the proud owner of another tenanted, positive cash flow property returning $600 a month gross. Taxes of $600 a year and water about the same.  $US6K NET a year on a property that cost $AUD8K Third and fourth were two single family dwellings in good areas.  These both cost $US14K each and returned $US700 a month each.  $US28K for two properties that gross around $US15K a year.   My fifth property was a tax foreclosure of a guy with 2 kids whose wife had left him and whose friend had stolen the money to repay the property taxes.  He was basically on the bones of his butt and was staring down the barrel of being homeless with two kids.  The property was in great condition in a reasonable part of town.  The property cost me $4K.  I signed up the previous owner in a land contract to buy his house back for $US30K. Payments over 10 years at 7% came out to around $US333 per month.  I made him an offer whereby if he acted as my property manager, i would forgo the land contract payments and pay him a percentage of the rents in exchange for his services. I would also pay for any work he did on the properties.  He jumped at it.  Seven years later, we're still working together and he keeps the properties humming.  Right now the AUD is around 80c US and looks like falling to around 65c by June 2015.  Rental income in Aussie $$ is around $2750 every month. This month (Jan 2015) I have transferred my property manager's house back to him with a quit claim deed and sold the remaining houses for $US100K  After taxes and commission I expect to receive in the vicinity of AUD$120K  Which is pretty good for a $AUD53K investment.  I've also received around $30K in rent a year. I'm of the belief I should be buying when everybody else is selling and selling when everybody else is buying.   I'm on the look-out for my next positive cash flow investment and I'm thinking maybe an emerging market smashed by the oil shock.   I wish you all happiness and success in your investment. Take care. VR

negative: Part 1 Quite a few [or rather most] countries allow USD account. So there is no conversion.   Just to illustrare; In India its allowed to have a USD account. The funds can be transfered as USD and withdrawn as USD, the interest is in USD. There no conversion at any point in time. Typically the rates for CD on USD account was Central Bank regulated rate of 5%, recently this was deregulated, and some banks offer around 7% interest.   Why is the rate high on USD in India? - There is a trade deficit which means India gets less USD and has to pay More USD to buy stuff [Oil and other essential items]. - The balance is typically borrowed say from IMF or other countries etc. - Allowing Banks to offer high interest rate is one way to attract more USD into the country in short term. [because somepoint in time they may take back the USD out of India] So why isn't everyone jumping and making USD investiments in India? - The Non-Residents who eventually plan to come back have invested in USD in India. - There is a risk of regulation changes, ie if the Central Bank / Country comes up pressure for Forex Reserves, they may make it difficut to take back the USD. IE they may impose charges / taxes or force conversion on such accounts. - The KYC norms make it difficult for Indian Bank to attract US citizens [except Non Resident Indians] - Certain countries would have explicit regulations to prevent Other Nationals from investing in such products as they may lead to volatility [ie all of them suddenly pull out the funds] - There would be no insurance to foreign nationals.   Part 2 The FDIC insurance is not the reason for lower rates. Most countires have similar insurance for Bank deposits for account holdes.   The reason for lower interst rate is all the Goverments [China etc] park the excess funds in US Treasuries because; 1. It is safe 2. It is required for any international purchase 3. It is very liquid.   Now if the US Fed started giving higher interest rates to tresaury bonds say 5%, it essentially paying more to other countries ... so its keeping the interest rates low even at 1% there are enough people [institutions / governemnts] who would keep the money with US Treasury.   So the US Treasury has to make some revenue from the funds kept at it ... it lends at lower interest rates to Bank ... who in turn lend it to borrowers [both corporate and retail].   Now if they can borrow cheaply from Fed, why would they pay more to Individual Retail on CD?, they will pay less; because the lending rates are low as well.   Part 3 Check out the regulations


query: Why use accounting software like Quickbooks instead of Excel spreadsheets?

positive: "I would say that all of the reasons you list in your question are valid, and I would add the following... You are in the landscaping business, not the accounting business. If you manage everything in spreadsheets, at least one of you has to become the bookkeeper and leave the landscaping to the others. Spreadsheets are ""agnostic"" in how you use them, so you have to turn them into an accounting system, which means you're now not only more of a bookkeeper, but you're also more of a developer, too, and even less of a landscaper. Accounting software is already developed by developers who understand accounting. Using it requires you to only perform the data entry tasks, and then you can focus on the landscaping, customer service, sales and marketing, etc., things that actually contribute to your business.  It is still good for you to understand basic accounting principles. Specialized accounting software will guide you through the process of learning and help you avoid making many of the costly mistakes you might have made in that learning process."

positive: I think your reasons are good. Fundamentally accounting software is built to ensure you record your accounting data effectively with minimal mistakes and good auditing. But you still need to use the tool properly to get the benefit. One other advantage is that many accountants are familiar with, say QuickBooks, and can do your accounts more effectively if you use their preferred tool.

positive: I would add to your reasons: Would you mow an entire lawn with a string trimmer just because you can, or would you buy a lawnmower? Use the right tool for the job.

positive: "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."

positive: Why use spreadsheets rather than writing your forms and formulas directly in a programming lanuage? Because you've got better things to do than reinvent the wheel, right? Same answer. ===== clarification, since the point apparently wasn't clear: Using a spreadsheet means you're writing and organizing and maintaining the formats and formulas yourself. Essentially, you are writing your own accounting program, using the spreadsheet program as your programming language. Nothing wrong with that, it just means you're doing work to produce something that you could have purchased instead. It's up to you to decide how the value of your time doing that work trades off against the cost of the commercial product.  For many people, especially as the bookkeeping becomes more complex, that isn't a good investment of their time. The otherwise billable time it would take them to maintain the spreadsheet is worth more than the cost of buying an off-the-shelf product, and the product offers features that they wouldn't get around to adding to their own solution. Add to that the question of whether people find creating and tweaking spreadsheets rewarding or annoying. The right tool is always the one that lets you focus on what you actually care about, unless the cost is too high to justify it.Most folks care about getting the accounting task done a least cost/least efprt. Buying a solution is least effort; if the real cost including time/effort is also lower, that's the direction they're going to go. I maintained my own accounts, and did my taxes, in spreadsheets for quite some time. These days the time to do so, multiplied by what my time is worth, would exceed the cost of buying tools, and the commercial tools are more pleasant to use, less prone to accidents, and offer featured that I don't need but appreciate. I still use a stylesheet for one small calculation (rebalancing my invedtments) but thst's because I havean odd corner case the built-in tool doesn't handle well...not that it makes any practival difference, but being slightly off annoyed me.  Your milage, obviously, will vary. Use the tool that suits your needs; others will do likewise.

positive: Here are the few points: Hope that helps,

negative: "If you are using software like QuickBooks (or even just using spreadsheets or tracking this without software) use two Equity accounts, something like ""Capital Contributions"" and ""Capital Distributions"" When you write a personal check to the company, the money goes into the company's checking account and also increases the Capital Contribution account in accordance with double-entry accounting practices. When the company has enough retained earnings to pay you back, you use the Capital Distributions equity account and just write yourself a check. You can also make general journal entries every year to zero out or balance your two capital accounts with Retained Earnings, which (I think) is an automatically generated Equity account in QuickBooks. If this sounds too complex, you could also just use a single ""Capital Contributions and Distributions"" equity account for your contributions and distributions."

negative: I use GnuCash which I really like.  However, I've never used any other personal finance software so I can't really compare.  Before GnuCash, I used an Excel spreadsheet which works fine for very basic finances. Pros Cons

negative: Business bookkeeping services helps small businesses in all aspect of managing their accounts and financial data within the accounting software. We have expertise in following accounting software QuickBooks, MYOB, and Peachtree. We have also used other small business accounting software like Great  plain, Simply Accounting, etc. Using this software we can produce various reports, graphs, and other analysis documents to help you in your bookkeeping tasks.

negative: The company I work with uses Intuit QuickBooks Online and have had zero problems with it. The functionality is effective and it fits the size of our company as well. (Not huge, but I wouldn't consider it a 'small business') Also, you can try a 30 day free trial. QuickBooks Simple Start focuses on small business accounting, so for this reason it has a cleaner interface and is simple to use. QuickBooks Simple Start compared to Quicken Home This article doesn't exactly have a bright light shining on Quickbooks, but I think it's fair to show you other alternatives: http://www.pcmag.com/article2/0,2817,2382514,00.asp [Note that it is from 2011]

negative: A desktop application that has the same features (although as already stated, nothing will be identical but if you are looking for functionality then certainly there will be) and pretty simple to use was Microsoft Money, however, Microsoft stopped supporting it with newer versions and while the existing versions will work, I still use mine, there will be no future updates. I like the interface, its simple to use and has all the features you want. They abandoned it in favor of Intuit's Quicken but personally I am not a fan of the Quicken interface. They still had a more extensive and probably too much for the average user application called Office Accounting, but they abandoned future updates and supports on that in favor of Intuit's Quickbooks. Again, I am not a fan of the interface but they are very feature rich including invoicing and payroll, again overkill for the average user. They still have the Small Business Accounting in the form of Microsoft Dynamics, but that is utterly overkill for personal use. I generally don't trust online or cloud based accounting solutions like Mint or even Quicken online because I don't trust my information security to some third party without knowing how they are securing it and what will happen to me if/when they are leaked due to breach. So I like to keep everything local to myself and that's a good move for you, you should do that. It seems at the moment the market standard without much competition is Quicken for personal use and Quickbooks for small business. I would recommend you start with Quicken and if your needs increase in the future, you can easily transfer into Quickbooks to scale up as they are fully compatible with each other. Check it out here and compare their products to see what works best for your needs.

negative: Not sure you are going to find anything like this in Excel - with the automatic lookup in specific. Microsoft has a template available; but it looks to be a pretty busy page. Why not look at other software?  If you have a PC, Quicken and Microsoft Money are of course the big guns.  You don't mention why you switched away from MS Money... There are many other packages as well.  The one that I use (but have no other financial interest in) is Moneydance as it was the best on Mac at the time I was looking.  It also runs on Windows and Linux.

negative: I like Quicken for personal use, and they have a small business edition if you don't want to move into QuickBooks.

negative: Our Finance organization does much of their reporting out of Excel being fed out of SSAS cubes, and beyond that, there's significant need for PowerPivot charts, forecasting, and Monte Carlo simulation, as well as significant use of various plugins and VBA code.  We kept Office 365 ProPlus around for Finance and HR.  For the rest of the organization, they don't need particularly advanced capabilities for slides, drawing, or word processing, or light spreadsheet capability and we're quite content to output to PDF, Google Sheets, and other things as needed, as well as using cost free alternatives to MS Exchange/Outlook, Visio, and Project.  The collaboration is a particular plus, and Google Hangouts is really convenient working from multiple sites/screen sharing.  We've done our best to keep our data centralized and universally accessible, in lieu of living in Excel spreadsheets and MS Access databases as tribal knowledge.

negative: Any accounting software should be able to handle this.  When you invoice them, set the invoice date to the date of the event.  Then receive a partial payment against that invoice.  This will cause your accounting software to display the service income in the correct period as well.  So if you sent them invoice for August 7, 2014 event on May 5th, 2014 and they gave you $500 due, you would see this Income in August ($500 on Cash basis, $1000 on Accrual basis.  When you received the other $500 in August, you would see $1000 for both methods).  You would not see any income in May, when you created the invoice.  This is better for revenue matching with the correct period. When you send them same invoice (say 30 days before the event), Set the software to show payments already received  (it seems that most online accounting software will do this by default).  Here is an example in Freshbooks.    Here is an example in Xero:  Seems they both display information on when you can expect payment on the their respective dashboards.   In the Desktop version of Quickbooks (which I use a lot), it will not show the balance of the customer by default on an invoice.  You will have to modify the invoice template.  There are more details on that here.  In Desktop version of Quickbooks, you can look at Cash Flow Forecast report to see the expected amount coming in.   I hope that helps and good luck.

negative: QuickBooks online is one of the best accounting solution choice for small business owners. So here you find how to convert QB Desktop to QB Online. IF you need more detail and help related to this visit our page- https://www.wizxpert.com/convert-your-quickbooks-desktop-file-to-quickbooks-online/

negative: I use GNUCash. It's a bit more like Quickbooks than plain Quicken, but it's not all that complicated. Probably the most difficult part is understanding the idea of income accounts.  Benefits: For short term planning, I use scheduled transactions. If I'm spending more than I have, it'll show up here. Every paycheck and dollar spent or invested is recorded with the exact date I anticipate it will happen, 30 days in advance. If that would overdraw my checking account, the Future Minimum Balance field will go negative and red. This lets me move float to higher interest savings and retirement funds, and avoids overdraft fees or other mishaps. By looking 30 days ahead in detail, I have enough time to transfer from illiquid assets. For longer term planning, I keep a spreadsheet around that plans out annual expenses. If I'm spending more than I earn, it shows up here. I estimate everything: expenses, savings, taxes, and income. I need this because I have a lot of expenses that are far less frequent than monthly or paycheck-ly. The beauty of it is that once I've got it in place, I can duplicate the sheet and consider tweaks for say taking a new job or moving, or even just changing an insurance plan (probably less relevant for those with access to NHS). Especially when moving to take a new job, it's not as straightforward as comparing salaries, and thus having a document for the status quo to start from lets you focus on the parts that changed.

negative: I had to install Parallels to run another piece of (trading) software, so I typically just use Windows Excel within Parallels when I need extensive statistical analysis--then I get the best of both worlds:  Mac environment on everything but in depth Excel (run of the mill Excel for Mac works fine).  I hate Windows.

negative: often financial software is dire, with crappy interfaces and poorly integrated to the wider company. I have an ambition one day to create a modern human centred financial software that is focused on the task at hand rather than forcing the user to jump through unnecessary hoops. Also Excel should be banned for many reasons.

negative: I use QuickBooks online... It's really the best out there for the price, just make sure to never upgrade to an edition you aren't 100% sure you need or you're forever stuck essentially. That's the mess I'm in right now. Paying $20 more than necessary a month, but it's still cheaper than switching to, say, xero. The starter edition of QuickBooks online is a lot more powerful than the equivalent plans anywhere else for the price.

negative: You could create your own spreadsheet of Cash Flows and use the XIRR function in Excel: The formula is:

negative: "As your financial situation becomes more complex, it becomes increasingly more difficult to keep track of everything with a simple spreadsheet.  It is much easier to work with software that is specifically designed for personal finances. A good program will allow you to keep track of as many accounts as you want.  A great program will completely separate the different account balances (location of the money) from the budget category balances (purpose of the money).  Let me explain: When you set up the software, you will enter in all of your different bank accounts with their balances.  Perhaps you have three savings accounts and two checking accounts.  It doesn't matter.  When you are done entering those, the software will total them up, and the next job you have is assigning this money into different budget categories: your spending plan.  For example, you might put some of it into a grocery category, some into an entertainment category, some will be assigned to pay your next car insurance bill, and some will be an emergency fund.  (These categories are completely customizable, and your budget can be as broad or as detailed as you wish.)  When you deposit your paycheck, you assign that new income into budget categories as well.  It doesn't matter at this point which accounts your money are located in; the only thing that matters is that you own this money and you have access to it.  Now, you might want to use a certain account for a certain budget category, but you are not required to do so.  (For example, your grocery category money will probably be in your checking account, since you will be spending from it regularly.  Your emergency fund will hopefully be in an account that earns a little higher interest.) Once you take this approach, you might find you don't need as many bank accounts as you thought you did, because the software does the job of separating your money into different ""accounts"" for different purposes. I've written before about the different categories of personal finance software.  YNAB, Mvelopes, and EveryDollar are three examples of software that will take this approach of separating the concepts of the bank account and the budget category."

negative: You can make a capital contribution, not a loan. It's not a taxable event, no interest, and you can take a distribution later when the business has the money to pay you back. So yes, transfer the money. If you use software like Quickbooks, make use of unique accounts for tracking the contribution

negative: for starters get a cheap easy accounting software pack like quickbooks and have the salesmen train you on it's use and set-up. the 50k you put into the company will count as paid up share capital. then any future withdrawal from company account will show as loan to director.

negative: At my first job (moderate sized quant prop fund) we inexplicably used Macs. Excel on a mac is a nightmare- if you tried to graph more than, say, 2000 data points it would grind to a halt, though this was some time ago. In retrospect maybe they were conditioning us to program rather than use excel...

negative: see, anyone who isn't heavy finance which truthfully is a good 80% of the business, will be fine with the transition. My issue is how to support the remaining 20% of advanced Excel users to attempt to find other (hopefully better) ways to view and change the same data. We've had these talks several times over with the technology transformation team and the main takeaway is:  - most users misuse Excel as a work-around tool to address messy data/reports, so for these processes they want us to determine if the data could come out clean and could run the desired analytics on the data straight out of the source, then would there be a need for Excel?  For some models like Monte Carlo, etc, I believe those ones are going to have exceptions. But do you think it is understandable and feasible to attempt to remove all the misuses of Excel and instead work towards a better way to accomplish the same goal? Because I do find that a good amount of spreadsheet work is sometimes just cleaning up the report/data output before the real Excel magic happens.

negative: "One way to do these sorts of calculations is to use the spreadsheet version of IRS form 1040 available here.  This is provided by a private individual and is not an official IRS tool, but in practice it is usually accurate enough for these purposes.  You may have to spend some time figuring out where to enter the info.  However, if you enter your self-employment income on Schedule C, this spreadsheet will calculate the self-employment tax as well as the income tax.  An advantage is that it is the full 1040, so you can also select the standard deduction and the number of exemptions you are entitled to, enter ordinary W-2 income, even capital gains, etc. Of course you can also make use of other tax software to do this, but in my experience the ""Excel 1040"" is more convenient, as most websites and tax-prep software tend to be structured in a linear fashion and are more cumbersome to update in an ad-hoc way for purposes like tax estimation.  You can do whatever works for you, but I would recommend taking a look at the Excel 1040.  It is a surprisingly useful tool."

negative: So there are a lot of people that get into trouble in your type of self employment situation.  This is what I do, and I use google drive so there are no cost for tools.  However, having an accounting system is better. Getting in trouble with the IRS really sucks bad.

negative: "Both, really. Thanks for the insight.  What would someone have to do to ""show you"" that their an expert? Also, what level would you consider an expert? I can manuver a spreadsheet using only the keyboard and have used excel quite a bit, but have limited use with things like VLOOKUP/Pivot tables/VBA."

negative: "Note: Specific to UK. I can't recommend anything higher than Crunch - they act as your accountant and have their own cloud accounting software, so it's more expensive than just using cloud accounting software, but if you use an accountant to do your year-end anyway, then they cost about the same as using cloud accounting software plus using an accountant to do your year-end. The thing I like (as a software development contractor) is that I don't have to know or worry about different ledger accounts, or journal entries, or any of the other weird accounting things, etc. Most cloud accounting software claim to simplify accounting ""so that you can concentrate on running your business"" whereas the reality is that you still have to spend ages learning how to be an accountant just to fill it in correctly. With Crunch that's actually true, it does actually make it simple. I've used Crunch, Sage, and Xero, so my sample-set isn't very big - just thought I'd share my experiences. If you value your time and get annoyed by having to create multiple internal transfers between different ledgers just to do something simple, it's for you. This probably sounds like a sales pitch, but I have nothing to do with them and nothing to gain by recommending them. The only reason I'm so passionate is I started a new business to do an online shop and tried to use Crunch, but they don't do retail businesses. Only contractors/freelancers or simple service-based businesses (their software is geared up specifically for that which I guess is why it's more simple than the others). Anyway, so now I'm annoyed at having to use the more complicated ones."

negative: You can move money in and out of the business at will, just keep track of every transaction. Ideally you'd use an accounting software like QuickBooks or similar. Create a Capital Contributions account and every time you put money into the business checking account record it as a Capital Contribution. Likewise, if you take money out of the business, it comes from your capital accounts. (You can create a separate Capital Distributions account in your accounting software, or just use a single account for contributions and distributions). Money coming in and out of those capital accounts is not taxable because you will pay taxes based on net earnings regardless of whether or not you have distributed any profits. So there's no need to make a loan to the company, which would have tax consequences. To reimburse yourself for purchases already made, submit an expense report to the company. If the company is unfunded right now, you can make a capital contribution to cover current expenses, submit the expense report, and wait until you have some profits before paying out the expense report or making any distributions. Welcome to entrepreneurship.

negative: If held in one savings account, how can I easily manage what percentage is planned for which   purpose? I used a spreadsheet for some years, but found it clumsy for everyday use. Thus I wrote some software which my wife and I use for our short-term as well as long-term planning, available at http://budgeter.sourceforge.net. It specifically helps with splitting the money in one or several accounts into logical categories. (The software is not the most user-friendly ever, so there may be better suggestions that follow, but it works well for us. Please feel free to suggest improvements to it as well.)

negative: "I really wish someone would release a similar product to quickbooks, its so SLOW and clunky.  Its my number 1 question from my small business IT clients... ""is there anything out there besides quickbooks?""  I hear freshbooks is good, but everyone is so ingrained in the quickbooks way of doing things it would be a strugle to switch people to a different product."

negative: Probably because it's a question of Excel vs Access, not VBA vs SQL. You probably don't need VBA for any of the calcs that the OP mentions.  Excel is the one tool everyone uses in Finance. CR and SSRS require tools and permissions that the average guy simply won't have, and a level of expertise that is not useful for most front/middle-office analysis work.  I usually see these done in Excel. SSRS and CR seem like way overkill for something done trivially and transparently in Excel, whose presentation will change frequently anyway.  Depending on what OP is talking about, analysis is not reporting, and flexibility and transparency usually win. Especially when you want to poke around the underlying data and iterate with other people.  SSRS and CR only make sense when you know what you're looking for, that the data is appropriate for it and you don't expect it to change.

negative: First of all, consult an accountant who is familiar with tax laws and online businesses. While most accountants know tax laws, fewer know how to handle online income like you describe although the number is growing. Right now, since you're a minor, this complicates things a bit. That's why you'll need a tax accountant to come up with the best business structure to use. You'll need to keep your own records to estimate your quarterly taxes. At the amount you're making, you'll want to do this since you'll pay a substantial penalty at the end of the year if you don't. You can use a small business accounting software package for this or just track everything using Excel or the like.  As long as taxes are paid, you won't go to jail. But you need to pay them along with any penalties by April 15, 2013. If you don't do this, then the IRS will want to have a 'discussion' with you.

negative: The important followup is what KIND of financial analyst do you want to be? Unless you're doing VaR or advanced quant trading/risk analysis, Excel and VBA will be much more useful for making you excel at the day to day.

negative: If you can live with managing the individual category amounts yourself, this is trivial. Just set up a spreadsheet listing each category (and a column for the total amount of money in the account), adding or subtracting as you deposit or withdraw money to the account. To the bank it will be just one (physical) account, but to you, it can be any number of (accounting asset) accounts. You can choose to keep a history, or not. It's all up to how complex you want to make it. It doesn't even have to be a spreadsheet - you can just as well do this on paper if you prefer that. But the computer makes it easier. I imagine most personal finance software will help you, too; I know GnuCash can be coaxed into doing this with only a bit of creativity, and it almost certainly isn't the only one. I do this myself and it works very well. I don't know but imagine that companies do it all the time: there is no reason why there must be a one-to-one relationship between bank accounts and accounting asset accounts, and in fact, doing so would probably quickly become impractical.

negative: That's a rearrangement of the fisher equation; which is the correct way to determine real rates.  However, people often use the approximation real ≈ nominal - inflation; and if you're doing this for homework on software that is looking for exactly 1 numerical answer, they may be expecting you to use that instead.  Real interest rate is less formal nomenclature and refers to using the approximation.  Inflation-adjusted return is the equation.   In the real world you will use the approximation when you're figuring out a real rate while you're talking mid-sentence during a meeting; and use the equation in spreadsheets/calculations.