Monday, April 21, 2014

Learning Tax-Strategy Lessons the Hard Way

John Rafal for Forbes writes: To say that many people got a rude awakening in the last six weeks courtesy of the Internal Revenue Service would be an understatement. Taxes for ordinary income went from a maximum of 36% to 39.6% — plus a Medicare add-on of 1.45% and health-care reform surtax of .9% for a total of 41.95%. Taxes for long-term capital gains and qualified dividends increased from 15% to 23.8%, including 3.8% for the health-care-reform surtax. Taxable bond interest went from 35% to 43.4%, as did short -term capital gains and non-qualifying dividends. The overall effect was a general tax increase of about 7% to 9% depending on where your income falls.
These changes caught many people unaware. The result: a larger tax bill that left people digging into cash reserves or liquidating assets. For others, there was the additional penalty for underpayment.
You already know the bad news about taxes. The good news (yes, there is some): There are investment opportunities and vehicles worth exploring that could lower your 2014 tax burden. But you must be informed, proactive, and willing to engage both your financial advisor and CPA well before the end of the year to get the maximum benefit appropriate for your situation.
To avoid being caught by surprise next year, I suggest you explore the following four strategies:  [snip]  The article Continues @ Forbes, click here.
Posted on 4:50 PM | Categories:

The Taxing Side of Divorce: After the DOMA Decision

Mary V Ade for Stout Risiou Ross writes: Under the Supreme Court’s ruling in United States v. Windsor, same-sex couples will now be treated as married for all federal tax purposes, including income and gift and estate taxes. The ruling applies to all federal tax provisions where marriage is a factor, including filing status, claiming personal and dependency exemptions, taking the standard deduction, employee benefits, contributing to an IRA, and claiming the earned income tax credit or child tax credit.

Any same-sex marriage legally entered into in one of the 50 states, the District of Columbia, a U.S. territory, or a foreign country will be covered by the ruling. However, the ruling does not apply to registered domestic partnerships, civil unions, or similar formal relationships recognized under state law.
The U.S. Department of the Treasury and the Internal Revenue Service (IRS) ruled that same-sex couples, legally married in jurisdictions that recognize their marriages, will be treated as married for federal tax purposes. The ruling applies regardless of whether the couple lives in a jurisdiction that recognizes same-sex marriage or a jurisdiction that does not recognize same-sex marriage.
General Implications
Legally married same-sex couples generally must file their 2013 federal income tax return(s) using either the married filing jointly or married filing separately filing status.
Individuals who are in same-sex marriages may, but are not required to, file original or amended returns, choosing to be treated as married for federal tax purposes for one or more prior tax years still open under the statute of limitations.
Employees who purchased same-sex spouse health insurance coverage from their employers on an after-tax basis may treat the amounts paid for that coverage as pre-tax and excludable from income.
Specific Guidance 
When are individuals of the same sex lawfully married for federal tax purposes?
For federal tax purposes, the IRS looks to state or foreign law to determine whether individuals are married. The IRS has a general rule recognizing a marriage of same-sex spouses that was validly entered into in a domestic or foreign jurisdiction whose laws authorize the marriage of two individuals of the same sex even if the married couple resides in a domestic or foreign jurisdiction that does not recognize the validity of same-sex marriages.
Can same-sex spouses file federal tax returns using a married filing jointly or married filing separately status?
For tax year 2013 and going forward, same-sex spouses generally must file using a married filing separately or jointly filing status. For tax year 2012 and all prior years, same-sex spouses who file an original tax return on or after September 16, 2013 (the effective date of Rev. Rul. 2013-17), generally must file using a married filing separately or jointly filing status. For tax year 2012, same-sex spouses who filed their tax return before September 16, 2013, may choose (but are not required) to amend their federal tax returns to file using married filing separately or jointly filing status. For tax years 2011 and earlier, same-sex spouses who filed their tax returns timely may choose (but are not required) to amend their federal tax returns to file using married filing separately or jointly filing status provided the period of limitations for amending the return has not expired. A taxpayer generally may file a claim for refund for three years from the date the return was filed or two years from the date the tax was paid, whichever is later.
Taxpayers who wish to file a refund claim for income taxes should use Form 1040X, Amended U.S. Individual Income Tax Return. Taxpayers who wish to file a refund claim for gift or estate taxes should file Form 843, Claim for Refund and Request for Abatement.
Can a taxpayer and his or her same-sex spouse file a joint return if they were married in a state that recognizes samesex marriages but they live in a state that does not recognize their marriage?
For federal tax purposes, the IRS has a general rule recognizing a marriage of same-sex individuals that was validly entered into in a domestic or foreign jurisdiction whose laws authorize the marriage of two individuals of the same sex even if the married couple resides in a domestic or foreign jurisdiction that does not recognize the validity of same-sex marriages.
Can a taxpayer’s same-sex spouse be a dependent of the taxpayer?
No. A taxpayer’s spouse cannot be a dependent of the taxpayer.
Can a same-sex spouse file using head of household filing status?
A taxpayer who is married cannot file using head of household filing status. However, a married taxpayer may be considered unmarried and may use the head-of-household filing status if the taxpayer lives apart from his or her spouse for the last six months of the taxable year and provides more than half the cost of maintaining a household that is the principal place of abode of the taxpayer’s dependent child for more than half of the year.
If same-sex spouses (who file using the married filing separately status) have a child, which parent may claim the child as a dependent?
If a child is a qualifying child under section 152(c) of both parents who are spouses (who file using the married filing separate status), either parent, but not both, may claim a dependency deduction for the qualifying child. If both parents claim a dependency deduction for the child on their income tax returns, the IRS will treat the child as the qualifying child of the parent with whom the child resides for the longer period of time during the taxable year. If the child resides with each parent for the same amount of time during the taxable year, the IRS will treat the child as the qualifying child of the parent with the higher adjusted gross income.
Can a taxpayer who is married to a person of the same sex claim the standard deduction if the taxpayer’s spouse itemized deductions?
No. If a taxpayer’s spouse itemized his or her deductions, the taxpayer cannot claim the standard deduction (IRC section 63(c)(6)(A)).
If a taxpayer adopts the child of his or her same-sex spouse as a second parent or co-parent, may the taxpayer (“adopting parent”) claim the adoption credit for the qualifying adoption expenses he or she pays or incurs to adopt the child?
No. The adopting parent may not claim an adoption credit. A taxpayer may not claim an adoption credit for expenses incurred in adopting the child of the taxpayer’s spouse (IRC section 23).
Do provisions of the federal tax law such as section 66 (treatment of community income) and section 469(i)(5) ($25,000 offset for passive activity losses for rental real estate activities) apply to same-sex spouses?
Yes. Like other provisions of the federal tax law that apply to married taxpayers, section 66 and section 469(i)(5) apply to same-sex spouses because same-sex spouses are married for all federal tax purposes.
If an employer provided health coverage for an employee’s same-sex spouse and included the value of that coverage in the employee’s gross income, can the employee file an amended Form 1040 reflecting the employee’s status as a married individual to recover federal income tax paid on the value of the health coverage of the employee’s spouse?
Yes, for all years for which the period of limitations for filing a claim for refund is open. Generally, a taxpayer may file a claim for refund for three years from the date the return was filed or two years from the date the tax was paid, whichever is later. If an employer provided health coverage for an employee’s same-sex spouse, the employee may claim a refund of income taxes paid on the value of coverage that would have been excluded from income had the employee’s spouse been recognized as the employee’s legal spouse for tax purposes. This claim for a refund generally would be made through the filing of an amended Form 1040.
Example: Employer sponsors a group health plan covering eligible employees and their dependents and spouses (including samesex spouses). Fifty percent of the cost of health coverage elected by employees is paid by Employer. Employee A was married to same-sex Spouse B at all times during 2012. Employee A elected coverage for Spouse B through Employer’s group health plan beginning January 1, 2012. The value of the employer-funded portion of Spouse B’s health coverage was $250 per month.
The amount in Box 1, “Wages, tips, other compensation,” of the 2012 Form W-2 provided by Employer to Employee A included $3,000 ($250 per month x 12 months) of income reflecting the value of employer-funded health coverage provided to Spouse B. Employee A filed Form 1040 for the 2012 taxable year reflecting the Box 1 amount reported on Form W-2.
Employee A may file an amended Form 1040 for the 2012 taxable year excluding the value of Spouse B’s employer-funded health coverage ($3,000) from gross income.
If an employer sponsored a cafeteria plan that allowed employees to pay premiums for health coverage on a pre-tax basis, can a participating employee file an amended return to recover income taxes paid on premiums that the employee paid on an after-tax basis for the health coverage of the employee’s same-sex spouse?
Yes, for all years for which the period of limitations for filing a claim for refund is open. Generally, a taxpayer may file a claim for refund for three years from the date the return was filed or two years from the date the tax was paid, whichever is later. If an employer sponsored a cafeteria plan under which an employee elected to pay for health coverage for the employee on a pre-tax basis, and if the employee purchased coverage on an after-tax basis for the employee’s same-sex spouse under the employer’s health plan, the employee may claim a refund of income taxes paid on the premiums for the coverage of the employee’s spouse. This claim for a refund generally would be made through the filing of an amended Form 1040.
Example: Employer sponsors a group health plan as part of a calendar year cafeteria plan. The full cost of spousal and dependent coverage is paid by the employees. In the open enrollment period for the 2012 plan year, Employee C elected to purchase selfonly health coverage through salary reduction under Employer’s cafeteria plan. On March 1, 2012, Employee C was married to same-sex Spouse D. Employee C purchased health coverage for Spouse D through Employer’s group health plan beginning March 1, 2012. The premium paid by Employee C for Spouse D’s health coverage was $500 per month.
The amount in Box 1, “Wages, tips, other compensation,” of the 2012 Form W-2 provided by Employer to Employee C included the $5,000 ($500 per month x 10 months) of premiums paid by Employee C for Spouse D’s health coverage. Employee C filed Form 1040 for the 2012 taxable year reflecting the Box 1 amount reported on Form W-2.
Employee C’s salary reduction election is treated as including the value of the same-sex spousal coverage purchased for Spouse D. Employee C may file an amended Form 1040 for the 2012 taxable year excluding the premiums paid for Spouse D’s health coverage ($5,000) from gross income.
If a sole proprietor employs his or her same-sex spouse in his or her business, can the sole proprietor get a refund of Social Security, Medicare, and Federal Unemployment Tax Act (FUTA) taxes on the wages that the sole proprietor paid to the same-sex spouse as an employee in the business?
Services performed by an employee in the employment of his or her spouse are excluded from the definition of employment for purposes of the FUTA. Therefore, for all years for which the period of limitations is open, the sole proprietor can claim a refund of the FUTA tax paid on the compensation that the sole proprietor paid his or her same-sex spouse as an employee in the business. Services of a spouse are excluded from Social Security and Medicare taxes only if the services are not in the course of the employer’s trade or business, or if it is domestic service in a private home of the employer.
Conclusion
As more states recognize same-sex marriages, there will inevitably be same-sex divorce. The tax benefits afforded divorcing couples will then be extended to same-sex divorces.
Posted on 7:09 AM | Categories:

Real estate broker shows how to turn business mileage deduction into a negligence penalty

Stephen Fishman for Inman News writes: Jim Chapin, a California real estate broker, used his Toyota Sequoia SUV for his real estate business during 2009.  He figured that he drove a total of 11,135 miles for business that year and deducted $5,309 for car and truck expenses.
The IRS audited him and disallowed the entire deduction, and also added on a 20 percent negligence penalty. Chapin appealed to the Tax Court and lost.
Here’s what he did wrong:
Mistake No. 1: Not keeping a business mileage log
Business mileage deductions are closely scrutinized by the IRS because they are commonly abused by taxpayers. You must keep a record of:
- See more at: http://www.inman.com/2014/04/21/real-estate-broker-shows-how-to-turn-business-mileage-deduction-into-a-negligence-penalty/#sthash.Zh5sC73N.dpuf

  • your mileage
  • the dates of your business trips
  • the places you drove for business, and
  • the business purpose for your trips.
The IRS wants to know the total number of miles you drove during the year for business, commuting and personal driving other than commuting. By far the best way to prove to the IRS how much you drove for business is to keep contemporaneous records. “Contemporaneous” means your records are created each day you drive for business, or soon thereafter.
To keep track of your driving, you can use either a paper mileage logbook that you keep in your car or an electronic application. Logbooks are available in any stationery store and there are dozens of apps that you can use to record your mileage with an iPhone or similar device. There are even apps that use GPS tracking to automatically calculate your mileage for each trip.

However, like many people, Jim Chapin kept no contemporaneous records of his driving.
Mistake No. 2: Inadequate reconstructed records
Although a mileage log you keep every day is by far the best way to substantiate your car deductions, it isn’t absolutely required. If you fail to keep a log, you can reconstruct your mileage records in the event of an IRS audit. However, reconstructed records are inherently suspect and must be backed up by other corroborating evidence with, in the words of the Tax Court, “a high degree of probative value.”
Jim Chapin failed to do this. He created a handwritten chart with a list of places he claimed to have driven during March 2009. He also created an itemized list of his 2009 expenses for fuel, insurance, parts, registration and repairs. However, neither list indicated any business purpose for the trips, nor reported the mileage traveled or the amount of each trip expense.
Chapin apparently had no other documentary evidence to back up his lists, such as receipts, or calendar or appointment book entries. The Tax Court held that Chapin’s records weren’t sufficient and denied his entire $5,309 deduction.
Mistake No. 3: Mouthing off to the Tax Court
To add insult to injury, the Tax Court held that Chapin was liable for a 20 percent negligence penalty. The court found that his failure to maintain records to support his deductions was negligence.
Chapin didn’t help his case when he told the court that “no one keeps records in accordance with the IRS code.” Understandably, neither the IRS nor the Tax Court will accept the argument that “everyone does it.” (Chapin v. Comm’r, T.C. Summ. Op. 2014-31.)
Stephen Fishman is a tax expert, attorney and author who has published 20 books, including “The Real Estate Agent’s Tax Deduction Guide,” “Working for Yourself,” “Deduct It!” and “Working with Independent Contractors.” His website can be found at fishmanlawandtaxfiles.com.
Posted on 7:05 AM | Categories:

Getting Started with Microsoft Power Business Intelligence for Office 365

Arshad Ali for Databasejournal.com writes: Microsoft Excel is one of the most widely used tools across the globe. Microsoft empowers Excel users to create Business Intelligence reports quickly in Excel itself with Power BI. Power BI is a familiar, intuitive and cloud based self-service BI (Business Intelligence) solution for all your data needs in your very own Excel, which users have been using for decades. It includes different tools for data discovery, analysis and visualization. Furthermore, Power BI integrates with Office 365 to share, collaborate and much more.

In my last article, I talked in brief about all the products and their purpose in creating self-service reporting in Excel; in this article I am going to talk in detail about how Power BI works for Office 365 and what features they provide.

Getting Started with Microsoft Power BI for Office 365
Office 365 is cloud based Software as a Service (SaaS) offering built on a scalable, manageable, trusted platform and offers access to various services and software built around the Microsoft Office.

Power BI integrates with Office 365 to better provide self-service analytics in the cloud, better collaboration capabilities as users can now share reports they have created with other folks in the organization with the help of Office 365 online services and use Mobile BI to view reports on any mobile devices supporting HTML5.

To start with, you need to visit http://powerbi.com/, click on “Free Trial” (if you want to try it out or click on “Buy Now” to buy it). This will take you to a sign up page for setting up your subscription, fill up the information and click on “create my account” to get start with your subscription.

Purchase and pricing details for Power BI for Office 365 is available here.
Start your free trial
Start your free trial

The Office 365 admin center page will display the progress of the provisioning as it takes 10-15 minutes time to provision Power BI for Office 365. Once completed you can see “No issues” as shown below:

Office 365
Office 365
Once Power BI for the Office 365 site is created, you can click on Power BI under theAdmin menu on the top right corner of the Office 365 admin center page as shown below.

Power BI
Power BI
You might face an issue as shown below. As you can see the logging account, under which I have logged in, does not have a user subscription assigned and hence I need to do that first before I can administer it:
No Power BI for Office 365 License
No Power BI for Office 365 License
Click on Users and Groups link on the Office 365 admin page available on the left or click onAssign user licenses available under admin shortcuts on the right as shown below:

Admin Shortcuts
Admin Shortcuts
On the next screen, you need to first choose the user to whom you want to assign a user license and then on the subsequent page assign Microsoft Power BI for Office 365 as shown below:
Assign Microsoft Power BI for Office 365
Assign Microsoft Power BI for Office 365
Now if you go back again and click on Power BI under Admin on the Office 365 admin center page, it will take you to the Power BI admin center page. From here you can administer and manager Power BI for your subscription; for example you can manage security, data management gateway – which allows you to make data available to user while searching in Power Query, – etc.
Power BI admin center
Power BI admin center
By default a site collection gets created with the domain name you specify when registering (though you can even create more site collection or site after registration apart from the default one which was created during registration); for example, in my case I provided learnpowerbi as the domain name and hence this site was created for me:https://learnpowerbi.sharepoint.com/
AdventureWorks Technologies Team Site
AdventureWorks Technologies Team Site
To add the Power BI capability to your site, click on the Site Contents on the right and then hit Power BI as shown below:
AdventureWorks Technologies Team Site: Site Contents
AdventureWorks Technologies Team Site: Site Contents

This will start adding Power BI capability to your site and will ask if you want to add some sample files (Excel files with Power Pivot models and Power View reports) to play around. If you are new to Power BI, I would highly recommend you add them so that you can quickly start working on it and understand it quickly. Later on, if not required you can delete them:
Add Power BI Sample Data
Add Power BI Sample Data
This is how your Power BI site should look; you can see sample files added under theDocuments section. You can make any of the reports or questions to be featured and it should start appearing in the top section of the screen for quick access.
Power BI Site
Power BI Site
You can click on Add link to upload your own Excel documents with Power Pivot models and Power View reports:
Upload Your Own Excel Documents
Upload Your Own Excel Documents
If you click on any of the uploaded Excel documents, it should start showing reports as shown below. Notice on the bottom, you can click on any of the tabs to view different reports embedded in the Excel document. You can find Filters of the report on the right side, which can be collapsed or expanded as per your need.
Reports
Reports

Power BI Q&A

With Power BI Q&A you can ask questions in natural language and get back answers promptly, presented to you in a different visualization options. This feature allows users to discover, explore, and visualize their own enterprise data using natural language; answers to questions are shown in the form of visualization that changes dynamically as you modify the question, creating a truly interactive experience for your data. On the right side of the Power BI site, you can click on “Search with Power BI Q&A” as shown below:
Search with Power BI Q&A
Search with Power BI Q&A
Now you or your business users can type questions in natural language (no need to be a technology expert anymore to analyze the data) and get answer promptly.
Please note, currently Power BI Q&A works on the models you have deployed on the Power BI site as Excel documents (Power Pivot or Power View) and there might be changes in the future for broader support.
For example, as part of the sample file deployed, there is one file containing a model with population information and hence if I type “show population” as shown below, I can see the total population:
Population Information Model
Population Information Model
Next if I extend my question to “show population of India”, this is what it looks like:
Population Information Model Drilled Down
Population Information Model Drilled Down
Further, if I extend my question to “show population of India by year vs china”, this is how the report looks. One the right side of the report, you can see different visualization options to choose from:
Population Information Model Drilled Down
Population Information Model Drilled Down

Power BI Mobile App

Power BI for Office 365 introduces a mobile BI app that supports HTML 5 and allows you to view your Power View reports on any device supporting HTML5 hosted on Office 365 sites. This allows you to stay connected to your reports deployed on Power BI for Office 365 from wherever you go. You can explore reports (filtering, sorting and highlighting can be done in an interactive manner) with the touch optimized experience, and quickly share insights with colleagues, and quickly tag reports as favorites to access them later with one tap. You can download this Windows BI app from here.
Once downloaded the mobile app should look like this (this has sample reports to help you understand the app better):
Mobile App
Mobile App
When you right click on the mobile app, you will get an option to browse your own Power view reports deployed on Power BI for Office 365:
Browse Your Own Power View Reports
Browse Your Own Power View Reports
On the Browse screen, specify the location for Power BI for Office 365 site and credential to connect to it as shown below:
Power BI Authentication
Power BI Authentication
Now you can browse all your Power View reports (as part of an Excel workbook) deployed on the Power BI site (for which you have access rights) and select the one that you would like to view in the mobile app:
Shared Documents
Shared Documents
Once you are connected to the Excel document that contains the Power View reports, you can view all the “Views” of the report. You need to right click on the report and all the “Views” will start appearing on top as you can see below (for example, there are six views for the selected Power View report) and you can select any one of them or use the touch screen to move left or right to view different views.
Views
Views
Please note, the HTML5 version of Power View is a work in progress, so some visualizations may not yet work.
As the world of technology is changing quite rapidly, especially cloud computing, some of the options or features demonstrated in this article might change in the future. I would highly encourage you to refer to Power BI official documentation for the latest update.

Conclusion

Microsoft Power BI is familiar, intuitive and a cloud based self-service BI solution for all your data need in your very own Excel. It includes different tool for data discovery, analysis and visualization. In this article, I talked about how Power BI works with Office 365, how to get started with it and what features they provide. I also talked about mobile app to access Power BI reports on the go.
Posted on 7:00 AM | Categories:

ZapStitch Raises Seed Round / Zapstitch Integrates Quickbooks with Shopify

Sejal Mourya for NextBigWhat writes: Bangalore based @Zapstitch has raised an undisclosed amount of funding in seed round from Anupam Mittal along with the participation of other angel investors.
ZapStitch is a brainchild of Satya P Devarakonda, who also co-founded Yourbus which was recently acquired by Ibibio Group. The company offers a cloud integration platform which help SME’s to do data work in more efficient and time saving way.
It resolves the problem by integrating the data taken from various sources like ecommerce, CRM, accounting or from other cloud based apps. It basically cuts the time consuming process of transferring data from one app to another.
Currently, it integrates 4 Cloud business apps - Shopify, QuickBooks Online, BigCommerce, Magento. The company’s app is now used by more than 100 SMEs based in Australia, North America and UK.
Anupam Mittal is the founder and CEO of People Group which owns businesses such as Shaadi.com, Makaan.com, Mauj Mobile and People Pictures.


What QuickBooks versions are supported?

Our app currently works only with QuickBooks Online. We don’t support any other versions like QuickBooks Desktop, Pro, etc.

Do you support QuickBooks Online version of my country?

Technically, we support all countries. Majority of our happy customers are from USA, Canada, Australia, United Kingdom, and India. Few countries could have unique tax and accounting rules that might not be covered in our product.

Can I sync data from QuickBooks Online to Shopify?

Our public release of the product syncs data Only from Shopify to QuickBooks Online. Few customers suggested that we sync Products from QuickBooks to Shopify and sync Sales Orders and Customers from Shopify to QuickBooks. So, we released a beta product with this functionality. Currently, we enable this feature Only upon a request from a customer. No extra charge. Same pricing plans apply here.

Do you sync Inventory between Shopify and QuickBooks Online?

We would love to do this feature. Unfortunately, QuickBooks API does not support it yet. We cannot programmatically update / adjust inventory on QB Online. We are actively working with Intuit on this. As soon as that API is ready, we would support this feature. We *expect* this should be ready by April 1st, 2014.

Do you store any of my store or accounting data?

No. We don’t store your data on our servers. Since we don’t like others seeing or storing our own data, we follow the same with your data. We only use it while we are syncing it.

Can I schedule my syncs?

Our public release of the product does not allow you to schedule your syncs multiple times in a day. But, we enable this feature Only upon a request from a customer. No extra charge. Same pricing plans apply here.

Do you support multiple taxes? What if my shopify orders have different taxes?

We support Multiple Tax rates with a limitation. We look at tax rates in each of your Shopify orders and appropriately map them to a Single Tax Rate or Combined Tax Rate that is defined on your QuickBooks tax settings. But, if you have more than one tax code with the same Tax Rates, this logic might get matched to incorrect Tax Code Labels on your QuickBooks. In these cases, the financial numbers (e.g., Tax Rate 8.12%) would still be correct. It’s only the Tax Code Label (e.g., New York State Tax or Minnesota State Tax) that could be incorrect.

Do you support multiple Shopify stores to sync to 1 QuickBooks account?

Currently, we don’t support this feature as a public release. There is a workaround for this, though. You could create two separate accounts with us and use 1 Shopify Store for each account. But, again - we have not tested this functionality thoroughly. Please treat this is as a “labs” feature that you might want to risk your data with.
Posted on 2:32 AM | Categories: