Home Page link  

need report for sales tax paid items

  
Groups | Search | About
User Password
Register Now! Lost Password?

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
need report for sales tax paid items Phil Nelson 07-30-2007
Posted by Phil Nelson on July 30, 2007, 1:20 pm
Please log in for more thread options
 I need some help- In my service business, I resell quite a few items
that I paid sales tax for (various reasons, like in too much of a hurry
to deal with the permit process with a particular vendor), which I
thought I had dealt with well by entering them into my system (QB 2005)
with a notation (CATI) in the item name and "8.25% CA sales tax
included" added to the item description. I make the sales price exactly
the same as the cost (including the tax) and the item non-taxable.

Now I have a problem with my Sales and Use Tax return- State of CA wants
this broken out on the return, but I don't see how to get a report for
it in QB. I am hoping some QB report Guru can tell me how to report the
total tax paid on all these items. So far, my plan is to go through the
"Sales by Item Detail" report by hand and add everything with "CATI" in
it. I can do that (it's a fairly tiny business), but maybe there is a
better way?

Oh, and I need it today. :}

--
Phil Nelson

Posted by Phil Nelson on July 30, 2007, 4:17 pm
Please log in for more thread options
 Phil Nelson wrote:
> I need some help- In my service business, I resell quite a few items
> that I paid sales tax for (various reasons, like in too much of a hurry
> to deal with the permit process with a particular vendor), which I
> thought I had dealt with well by entering them into my system (QB 2005)
> with a notation (CATI) in the item name and "8.25% CA sales tax
> included" added to the item description. I make the sales price exactly
> the same as the cost (including the tax) and the item non-taxable.
>
> Now I have a problem with my Sales and Use Tax return- State of CA wants
> this broken out on the return, but I don't see how to get a report for
> it in QB. I am hoping some QB report Guru can tell me how to report the
> total tax paid on all these items. So far, my plan is to go through the
> "Sales by Item Detail" report by hand and add everything with "CATI" in
> it. I can do that (it's a fairly tiny business), but maybe there is a
> better way?
>
> Oh, and I need it today. :}
>

OK, I no longer need it today. I added the amounts from the report.
I would have exported to a spreadsheet, but I made the mistake of
including commas in many of the item names, which made CSV export
difficult and I use OpenOffice calc (can't afford Excel), so CSV is
the only export option available (apparently QB can only export to
Excel format if Excel is on the machine).

Still need an answer for next year. Maybe there is a better way to
handle items for which sales tax is paid at the time of purchase?

Thanks,

--
Phil Nelson

Posted by Laura on July 30, 2007, 4:30 pm
Please log in for more thread options

> Phil Nelson wrote:
>> I need some help- In my service business, I resell quite a few items that
>> I paid sales tax for (various reasons, like in too much of a hurry to
>> deal with the permit process with a particular vendor), which I thought I
>> had dealt with well by entering them into my system (QB 2005) with a
>> notation (CATI) in the item name and "8.25% CA sales tax included" added
>> to the item description. I make the sales price exactly the same as the
>> cost (including the tax) and the item non-taxable.
>>
>> Now I have a problem with my Sales and Use Tax return- State of CA wants
>> this broken out on the return, but I don't see how to get a report for it
>> in QB. I am hoping some QB report Guru can tell me how to report the
>> total tax paid on all these items. So far, my plan is to go through the
>> "Sales by Item Detail" report by hand and add everything with "CATI" in
>> it. I can do that (it's a fairly tiny business), but maybe there is a
>> better way?
>>
>> Oh, and I need it today. :}
>>
>
> OK, I no longer need it today. I added the amounts from the report.
> I would have exported to a spreadsheet, but I made the mistake of
> including commas in many of the item names, which made CSV export
> difficult and I use OpenOffice calc (can't afford Excel), so CSV is
> the only export option available (apparently QB can only export to
> Excel format if Excel is on the machine).
>
> Still need an answer for next year. Maybe there is a better way to
> handle items for which sales tax is paid at the time of purchase?
>
> Thanks,

Next year?? Most states require sales tax reported monthly or quarterly.



Posted by Phil Nelson on July 30, 2007, 5:30 pm
Please log in for more thread options
Laura wrote:
>

>> Still need an answer for next year. Maybe there is a better way to
>> handle items for which sales tax is paid at the time of purchase?
>>
>> Thanks,
>
> Next year?? Most states require sales tax reported monthly or quarterly.
>

And here I thought California was the state least friendly to small
business. What happened was, a while back when I went in to get my
license reinstated (after missing too many monthly or quarterly
reports), I explained that the overhead was likely to crush my tiny
company and the nice lady put me in the "fiscal year" program. I
don't remember the details, but I believe it's for businesses like
mine which are primarily service so they collect really tiny amounts
of sales tax. Note that "fiscal year" isn't my fiscal year (unless I
change it to fit theirs), it's 7/1 - 6/30.

Now that I look at it, it's the sort of deal that is so reasonable
and helpful that it's hard to believe I didn't miss something. So
don't take my word for it, but, "so far, so good".

Just so this isn't completely off-topic- it would be nice to have a
canned report for the CA "Fiscal Year" and maybe an option to set so
I don't have to adjust the date every time I do the sales taxes.

--
Phil Nelson

Posted by Laura on July 30, 2007, 6:30 pm
Please log in for more thread options

> Laura wrote:
>>
>
>>> Still need an answer for next year. Maybe there is a better way to
>>> handle items for which sales tax is paid at the time of purchase?
>>>
>>> Thanks,
>>
>> Next year?? Most states require sales tax reported monthly or quarterly.
>>
>
> And here I thought California was the state least friendly to small
> business. What happened was, a while back when I went in to get my
> license reinstated (after missing too many monthly or quarterly
> reports), I explained that the overhead was likely to crush my tiny
> company and the nice lady put me in the "fiscal year" program. I
> don't remember the details, but I believe it's for businesses like
> mine which are primarily service so they collect really tiny amounts
> of sales tax. Note that "fiscal year" isn't my fiscal year (unless I
> change it to fit theirs), it's 7/1 - 6/30.
>
> Now that I look at it, it's the sort of deal that is so reasonable
> and helpful that it's hard to believe I didn't miss something. So
> don't take my word for it, but, "so far, so good".
>
> Just so this isn't completely off-topic- it would be nice to have a
> canned report for the CA "Fiscal Year" and maybe an option to set so
> I don't have to adjust the date every time I do the sales taxes.

Run the report you like best and select the date range as "Last fiscal
year". Memorize the report and call it "Fiscal Year Sales tax report".


Similar ThreadsPosted
Verify Sales Tax Due with Use Tax Items January 7, 2008, 2:55 am
Problem With Sales Report - PLEASE!!! September 14, 2006, 5:59 pm
Sales by Customer Summary Report problem October 17, 2006, 12:02 pm
Can invoice show how it's paid for? June 17, 2006, 1:36 pm
Determine bills paid by credit after the fact November 22, 2006, 2:48 pm
Need Experts in QuickBooks for Paid Research Study April 16, 2008, 10:11 am
Invoices marked PAID show up in Receivables?? November 20, 2008, 10:30 am
Recording business expenses paid from personal credit card August 23, 2007, 8:07 pm
Sales tax? December 13, 2006, 8:53 am
Sales by Country July 18, 2006, 10:18 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap