|
Posted by Hawk on October 8, 2007, 10:23 pm
Please log in for more thread options Thanks Wayne & John,
Both your posts give some hope... But alas - I think it's quicker in the
long-run to just wait til the end of each quarter, and add up the
sales... We generally have about 200-250 invoices per quarter... and
about 90% are non-taxable (resale, church, and out-of-state sales... so
picking out the taxable ones, though, is a PITA.
For a while we ran a separate spreadsheet. Whenever we created a
quicken invoice, we'd enter the data including onlt the following info:
Invoice number, Invoice Date, Invoice subtotal, and tax collected.
Then I'd sort based on tax collected, and give a total sum of the
subtotal column, and then a sum of the invoices that had a "tax
collected" in excess of 1 cent.
I may go back to this method... We gave it up when I realized 2 years
ago that quicken would do invoices.. however, I think it's lacking in
some of the "basic" reports that a small business needs... Maybe in a
future version....
(Yep - we're in Dallas county as well - but even the Texas long form for
sales tax submissions is pretty easy.. then we file & pay via their
web-file.
Rex S.
Wayne wrote:
> shadowhawk@treasureboards.com says...
>>
>> Hello,
>>
>> I'm running Quicken 2005 Premier Home & Business - and have used Quicken
>> for our small business ever since we started - just about 10 years ago.
>>
>> I'm sort of discouraged, though when every quarter - when it's time to
>> submit my sales tax to the state (Texas), I have to manually add-up my
>> total sales (invoice sub totals), taxable sales (invoices that I charged
>> sales tax on), and sales tax collected..
>>
>> I've looked all through the quicken reports - and I just can't find an
>> easy way to extract what I'm looking for... is there one? Or am I
>> going to need to simply find a better accounting method?
>
>
> Tell me about it. :) No, Quicken does not help much.
>
> I am in a DFW area subject to DART MTA tax, so I also have to track city,
> regarding the 1% DART tzx. My sales tax is only a couple hundred dollars
> annually, so I only report the tax to the state once at year end.
>
> Most of my online sales are not in Texas, Quicken reports can count the
> total overall sales number. My Texas sales tax entry (from a Texas
> invoice) goes to the *Sales Tax* account. Which never seems to appear in
> any Quicken report (cannot find a Category to include for it), but from
> within that account, it can total it in the Register Report menu (for the
> year).
>
> But cities are a problem for me. The way I read the rules, because my
> city is DART MTA, I collect the MTA 1% from all DART MTA cities, but not
> from other cities. So what I do is for sales in Texas, I edit each one
> of those sales tax records as they occur, to add city to the Memo field in
> the *Sales Tax* account. This city then shows in the register report
> too, but you have to figure out what is what for subtotals. However this
> much alone should have a big impact, but is still tedious work.
>
> What I actually do is at year end, I export that *Sales Tax* account (for
> the year) to a qif file. Then I wrote a smell program to read it sort it
> and count it by city. That little program knows which cities are 8.25%
> with DART MTA, and the others are 7.25%.
>
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap