sql-ledger-users

RE: [SQL-Ledger-users] Tax summary

[Leo M. <Le...@Ne...>]

This sounds rather odd.  I was under the impression
that only the USA allows cash accounting for private
corporations.  Everywhere else requires accrual 
accounting which means that you count the funds
when accrued, not paid.  Canadian GST (another form
of VAT) works this way as well.  At least in Canada,
Dieter's suggestion will yield the correct results.

Regards,
Leo R Masciuch, M.B.A., P.Eng.
Netryst Corp.
5051 Vantage Cres NW
Calgary, AB  T3A 1X6
Canada
Tel: +1-403-202-5039
Fax: +1-403-202-5038
Le...@Ne...


-----Original Message-----
From: Adrian Blake [mailto:ad...@sn...]
Sent: Wednesday, March 07, 2001 22:45
To: sql...@li...
Subject: Re: [SQL-Ledger-users] Tax summary


Dieter Simader wrote:
> 
> You can produce a report for a specified time period from the 'Accounts
> List', click on your GST account and enter the dates. If you only need a
> total, generate a balance sheet up to the end of the period.
> 
> To see how much income and expenses you have for a 3 month period run off
> an income statement for the period. If you need a detailed list you can
> produce a report for each income and expense account from the 'Accounts
> List'.

OK, this is helpful, but if a payment has not been made in either AP or
AR then it cannot be counted in the GST calculations for that period.
And in my case the numbers are considerable!

Adrian
-- 
Adrian Blake  (MIEEE)
Smart Radio Systems Pty Ltd
26b Bombala St, Cooma, NSW 2630, Australia
Ph 61-2-64525555 Fax 61-2-64524317

RE: [SQL-Ledger-users] Tax summary

[Leo M. <Le...@Ne...>]

I suspect that to do GST/VAT on a cash basis and the rest
of the books on an accrual basis, you'd have to develop
the tax handling routines separately.  The only accounting
package that I've seen attempt the is QuickBooks and their
solution for cash accounting uses proportions applied to
accrual accounting.

I wonder if Dieter anticipated the nuances that would 
arise for each country's implementation of sales tax.  I
spent a number of years in the USA and it is a matter of
each municipality's implementation of sales tax.

Regards,
Leo R Masciuch, M.B.A., P.Eng.
Netryst Corp.
5051 Vantage Cres NW
Calgary, AB  T3A 1X6
Canada
Tel: +1-403-202-5039
Fax: +1-403-202-5038
Le...@Ne...


-----Original Message-----
From: Adrian Blake [mailto:ad...@sn...]
Sent: Thursday, March 08, 2001 16:59
To: sql...@li...
Subject: Re: [SQL-Ledger-users] Tax summary


Leo Masciuch wrote:
> 
> This sounds rather odd.  I was under the impression
> that only the USA allows cash accounting for private
> corporations.  Everywhere else requires accrual
> accounting which means that you count the funds
> when accrued, not paid.  Canadian GST (another form
> of VAT) works this way as well.  At least in Canada,
> Dieter's suggestion will yield the correct results.
> 

Yes you are correct, but more correctly in Australia businesses can
elect to operate on cash accounting or accrual, at least as far as the
GST reporting and return to the taxation office.

Thanks for the advice.

Adrian
-- 
Adrian Blake  (MIEEE)
Smart Radio Systems Pty Ltd
26b Bombala St, Cooma, NSW 2630, Australia
Ph 61-2-64525555 Fax 61-2-64524317

Re: [SQL-Ledger-users] Tax summary

[Adrian B. <ad...@sn...>]

Leo Masciuch wrote:
> 
> I suspect that to do GST/VAT on a cash basis and the rest
> of the books on an accrual basis, you'd have to develop
> the tax handling routines separately.  The only accounting
> package that I've seen attempt the is QuickBooks and their
> solution for cash accounting uses proportions applied to
> accrual accounting.
> 
> I wonder if Dieter anticipated the nuances that would
> arise for each country's implementation of sales tax.  I
> spent a number of years in the USA and it is a matter of
> each municipality's implementation of sales tax.
> 

All this has worked out well for me as I have discovered that the
taxation office here anticipated accrual accounting and I was thingking
in terms of cash accounting. They now owe me many 10s of thounsands of
dollars. :-) This is good when trying to build up assests.

Again thanks for the advice.

Adrian
-- 
Adrian Blake  (MIEEE)
Smart Radio Systems Pty Ltd
26b Bombala St, Cooma, NSW 2630, Australia
Ph 61-2-64525555 Fax 61-2-64524317

RE: [SQL-Ledger-users] Tax summary

[Dieter S. <dsi...@sq...>]

Adrian,

create seperate GST accounts and record the GST when you make a sale in
GST1 and make a GL entry from GST1 to GST2 when you get paid.

If you need to keep sales/income amounts and expenses seperate then create
seperate accounts for them too.

I allowed for two levels of tax for parts and two levels of tax for
services plus a general tax exclusion for sales to tax excempt customers.
This covers most everything in Canada, and as far as I know in the US. For
SQL-Ledger to work in Europe you'll have to do come up with some
workarounds. The folks down under are closest to our Canadian tax system,
albeit as we see now do have some peculiarities of their own.

There are some changes in the works which will make SQL-Ledger easier 
to adapt to different tax systems. These include taxes per item, any
number of taxes rather than the two levels now and tax included or not.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Thu, 8 Mar 2001, Leo Masciuch wrote:

> I suspect that to do GST/VAT on a cash basis and the rest
> of the books on an accrual basis, you'd have to develop
> the tax handling routines separately.  The only accounting
> package that I've seen attempt the is QuickBooks and their
> solution for cash accounting uses proportions applied to
> accrual accounting.
> 
> I wonder if Dieter anticipated the nuances that would 
> arise for each country's implementation of sales tax.  I
> spent a number of years in the USA and it is a matter of
> each municipality's implementation of sales tax.
> 
> Regards,
> Leo R Masciuch, M.B.A., P.Eng.
> Netryst Corp.
> 5051 Vantage Cres NW
> Calgary, AB  T3A 1X6
> Canada
> Tel: +1-403-202-5039
> Fax: +1-403-202-5038
> Le...@Ne...

[SQL-Ledger-users] multilevel tax / translation BR

[Andre F. M. <and...@te...>]

Hello, Dieter:

> There are some changes in the works which will make SQL-Ledger easier
> to adapt to different tax systems. These include taxes per item, any
> number of taxes rather than the two levels now and tax included or not=
.

Is there any guess of when the new multilevel tax scheme will be=20
released?
Here, in Brasil, there is a completely crazy tax system, with multiple=20
levels of taxes, tax credits and debts, a real nightmare (and cost!).

Please, correct the Brazilian Portuguese translation
Trial Balance -> Balan=E7o Preliminar

Many thanks.
Andre Felipe=20

RE: [SQL-Ledger-users] Tax summary

[Leo M. <Le...@Ne...>]

This is losing its relevance as Canadian reporting 
requirements changed, but Canada actually has two
classes which fit into your exempt category.  These
are the tax exempt and zero-rated, the later are
taxable sales at a rate of zero percent.  The
difference is that you are allowed input tax credits
against the taxable sales (even if at 0%) but not
against the exempt sales.  For most businesses, you
may have to proportion the two to determine what
input tax credits to claim.  Therefore, you will need
to differentiate between exempt sales and zero rated.

The US is another can of worms.  Depending on how
you set up your books, you may be tracking four 
different sales taxes such as in the Seattle area.
These taxes are: state, municipal, transit, and
entertainment.  The latter three will vary depending
on where the goods are delivered.  The metropolitan
Seattle area has about 20 municipalities in the
RTA (Regional Transit Authority) area.  The tax for
each municipality has to be tracked separately.

This week, the Canadian municipalities were lobbying 
for the right to impose such a taxation mess on 
Canadians in their municipalities.  What ever happened
to the KISS principle:  Keep It Simple, Stupid!

-----Original Message-----
From: Dieter Simader [mailto:dsi...@sq...]
Sent: Saturday, March 10, 2001 11:25
To: 'sql...@li...'
Subject: RE: [SQL-Ledger-users] Tax summary


Adrian,

create seperate GST accounts and record the GST when you make a sale in
GST1 and make a GL entry from GST1 to GST2 when you get paid.

If you need to keep sales/income amounts and expenses seperate then create
seperate accounts for them too.

I allowed for two levels of tax for parts and two levels of tax for
services plus a general tax exclusion for sales to tax excempt customers.
This covers most everything in Canada, and as far as I know in the US. For
SQL-Ledger to work in Europe you'll have to do come up with some
workarounds. The folks down under are closest to our Canadian tax system,
albeit as we see now do have some peculiarities of their own.

There are some changes in the works which will make SQL-Ledger easier 
to adapt to different tax systems. These include taxes per item, any
number of taxes rather than the two levels now and tax included or not.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Thu, 8 Mar 2001, Leo Masciuch wrote:

> I suspect that to do GST/VAT on a cash basis and the rest
> of the books on an accrual basis, you'd have to develop
> the tax handling routines separately.  The only accounting
> package that I've seen attempt the is QuickBooks and their
> solution for cash accounting uses proportions applied to
> accrual accounting.
> 
> I wonder if Dieter anticipated the nuances that would 
> arise for each country's implementation of sales tax.  I
> spent a number of years in the USA and it is a matter of
> each municipality's implementation of sales tax.
> 
> Regards,
> Leo R Masciuch, M.B.A., P.Eng.
> Netryst Corp.
> 5051 Vantage Cres NW
> Calgary, AB  T3A 1X6
> Canada
> Tel: +1-403-202-5039
> Fax: +1-403-202-5038
> Le...@Ne...

[SQL-Ledger-users] A / R + A / P Summary

[Joe U. S. O. I. <jo...@sa...>]

When doing the invoicing I noticed that we couldn't pull a report that gives
a
total outstanding A/R, without manually calculating it.

Is there anyone who has created such a beast for SQL Ledger. What we want is
something that we can request at any
given time to run a aged A/R report (and for that matter if there is one for
A/P also.)

Main reason:  we want to see what is owing us at any given time, from day to
day.

Thanks

Joe Ussia
Saved Online Inc
Director of Sales
(416) 907 5314   Office
(866) OPEN SAVE
(416) 907 5325    Fax
(416) 616 1363    Cellular
(416) 600 4703    Pager
jo...@sa...        Snail-Email
us...@mo... Wireless Email
Visit Us @   www.savedonline.com

Software and Web Development with Full Wireless Deployment
   We Are Your End-to-End Open Source Solutions Provider

*Stay Tuned for our NEW and Amazingly Dynamic Web Launch on April 2, 2001!
  Write it on your calendar not to forget!

Re: [SQL-Ledger-users] A / R + A / P Summary

[Adrian B. <ad...@sn...>]

"Joe Ussia, Saved Online Inc" wrote:
> 
> When doing the invoicing I noticed that we couldn't pull a report that gives
> a
> total outstanding A/R, without manually calculating it.
> 
> Is there anyone who has created such a beast for SQL Ledger. What we want is
> something that we can request at any
> given time to run a aged A/R report (and for that matter if there is one for
> A/P also.)
> 
> Main reason:  we want to see what is owing us at any given time, from day to
> day.


Easy, we just did it today, but for a different reason, GST.  Here it
is, changes to ca.cgi.  I have also attached the new file. Very rough
but seves the purpose. I someone would like to "pretty it up" feel free
to do so.

---------------------------------------------------------------------------------------------------

$sortroutine = $form->{sort};
######## print it all out sorted by date first

$total_debit = 0;
$total_credit = 0;

foreach $item (@transaction) {

    $debit = ($item->[4] < 0) ? sprintf("%.2f", -$item->[4]) : "&nbsp;";
    $credit = ($item->[4] >= 0) ? sprintf("%.2f", $item->[4]) :
"&nbsp;";
    $total_debit = $total_debit + $debit;
    $total_credit = $total_credit + $credit;     
    $total += $item->[4];

    $balance = sprintf("%.2f", abs($total) );
    $DRCR = ($item->[4] >= 0) ? $locale->text('CR') :
$locale->text('DR');

  $column_data{bydate} = qq|<td>$item->[0]</td>|;
  $column_data{bysource} = qq|<td>$item->[1]</td>|;
  $column_data{bycomment} = qq|<td>$item->[3]</td>|;
  
  print "<tr>";

  map { print $column_data{$_} } split(/ +/, $column_index);

print qq|
<td align=right>$debit</td>
<td align=right>$credit</td>
<td align=right>$balance</td>
<td>$DRCR</td>
</tr>|;

}
   print qq|
</table><br>
|;
print "Total debit  ";
print qq|
$total_debit <br> |;
print "    Total credit  ";
print qq|
$total_credit |;
  print qq|

</body>
</html>
|;

}

-------------------------------------------------------------------------------------------------------

Adrian
-- 
Adrian Blake  (MIEEE)
Smart Radio Systems Pty Ltd
26b Bombala St, Cooma, NSW 2630, Australia
Ph 61-2-64525555 Fax 61-2-64524317

Re: [SQL-Ledger-users] A / R + A / P Summary

[Roderick A. A. <raa...@ti...>]

On Tue, 20 Mar 2001, Adrian Blake wrote:


> Easy, we just did it today, but for a different reason, GST.  Here it
> is, changes to ca.cgi.  I have also attached the new file. Very rough
> but seves the purpose. I someone would like to "pretty it up" feel free
> to do so.

I'm a little confused (normal situation) and way less than an accountant.

What should happen/show-up with this updated ca.cgi file?  Tried a simple
invoice but didn't notice anything different.

I think (know) I missed the point of Joe Ussia's need.


TIA,
Rod
-- 

Re: [SQL-Ledger-users] A / R + A / P Summary

[Adrian B. <ad...@sn...>]

"Roderick A. Anderson" wrote:
> 
> On Tue, 20 Mar 2001, Adrian Blake wrote:
> 
> > Easy, we just did it today, but for a different reason, GST.  Here it
> > is, changes to ca.cgi.  I have also attached the new file. Very rough
> > but seves the purpose. I someone would like to "pretty it up" feel free
> > to do so.
> 
> I'm a little confused (normal situation) and way less than an accountant.
> 
> What should happen/show-up with this updated ca.cgi file?  Tried a simple
> invoice but didn't notice anything different.
> 

Go to reports, then accounts list, then any account number. The report
produced shows debits, credits, balances  and now the sum of the debits
and credits.  this is useful for me in producing our GST returns.

Adrian
-- 
Adrian Blake  (MIEEE)
Smart Radio Systems Pty Ltd
26b Bombala St, Cooma, NSW 2630, Australia
Ph 61-2-64525555 Fax 61-2-64524317

Re: [SQL-Ledger-users] A / R + A / P Summary

[Roderick A. A. <raa...@ti...>]

On Fri, 23 Mar 2001, Adrian Blake wrote:

> Go to reports, then accounts list, then any account number. The report
> produced shows debits, credits, balances  and now the sum of the debits
> and credits.  this is useful for me in producing our GST returns.

Thanks.  I let the 'A/R' detour me in to the A/R menu without reading the
post carefully.  Of course since I'm just starting up _really using_
Sql-Ledger I've never used this report so I don't see the difference.  
Still being my own SysAdmin means I can put the old one back, check the
differences and say 'aaaahhh'.


Thanks for your help,
Rod
-- 

Re: [SQL-Ledger-users] Tax summary

[Adrian B. <ad...@sn...>]

Leo Masciuch wrote:
> 
> This sounds rather odd.  I was under the impression
> that only the USA allows cash accounting for private
> corporations.  Everywhere else requires accrual
> accounting which means that you count the funds
> when accrued, not paid.  Canadian GST (another form
> of VAT) works this way as well.  At least in Canada,
> Dieter's suggestion will yield the correct results.
> 

Yes you are correct, but more correctly in Australia businesses can
elect to operate on cash accounting or accrual, at least as far as the
GST reporting and return to the taxation office.

Thanks for the advice.

Adrian
-- 
Adrian Blake  (MIEEE)
Smart Radio Systems Pty Ltd
26b Bombala St, Cooma, NSW 2630, Australia
Ph 61-2-64525555 Fax 61-2-64524317