Menu
▾
▴
sql-ledger-users
|
From: Dieter S. <dsi...@sq...> - 2001-05-28 16:58:11
|
A brief overview how to set it all up and how it works. 1. Add an account in the chart of accounts. 2. check the box "Tax" if you want Receivables -> a field to enter an amount in the receivables form Payables -> a field to enter an amount in the payables form Parts Inventory -> a checkbox with the description in the parts form to indicate that this part is taxable Service Item -> a checkbox with the description in the service item form to indicate that the service is taxable 3. check "Yes" next to "Include this account on ..." if the account should be included on the customer / vendor forms to indicate that the customer / vendor is taxable at this level Repeat above for each tax you have. i.e if you have VAT @ 10, 14 and 30% add an account for each tax. 4. edit your preferences and enter a tax rate and tax number On an invoice the tax can either be included in the price or shown separately. If tax is included in the price the tax portion is not shown on the invoice. Taxes are only calculated if the customer/vendor is taxable at the same rate as the item. So, if a customer is taxable at VAT @ 10% and the item is set taxable at VAT @ 30% no taxes will be calculated. You must also indicate that the customer is taxable at VAT @ 30%. Taxes are calculated differently if included in price or shown on top. i.e. $100 item, taxable at 7% tax included -> net price is 93.46, tax portion is 6.54 tax on top -> net price is 100.00, tax is 7.00 multiple taxes are always additive and not calculated tax on tax. So, the same $100 item at 7% and 8% tax included -> net price is 86.96, tax is 13.04 tax on top -> net price is 100.00, tax is 15.00 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 =========== |
|
From: Antonio G. <ag...@ib...> - 2001-05-28 17:42:22
|
Dieter: What about the payments? Why we cannot use an account for payments. To track the history of when and how much a customer pays or we pay to a provider. Antonio Gallardo. ----- Original Message ----- From: "Dieter Simader" <dsi...@sq...> To: <sql...@li...> Sent: Monday, May 28, 2001 10:58 AM Subject: About Taxes > A brief overview how to set it all up and how it works. > > 1. Add an account in the chart of accounts. > > 2. check the box "Tax" if you want > Receivables -> a field to enter an amount in the receivables form > Payables -> a field to enter an amount in the payables form > Parts Inventory -> a checkbox with the description in the parts form to > indicate that this part is taxable > Service Item -> a checkbox with the description in the service > item form to indicate that the service is taxable > > 3. check "Yes" next to "Include this account on ..." if the account should > be included on the customer / vendor forms to indicate that the customer / > vendor is taxable at this level > > Repeat above for each tax you have. i.e if you have VAT @ 10, 14 and 30% > add an account for each tax. > > 4. edit your preferences and enter a tax rate and tax number > > > On an invoice the tax can either be included in the price or shown > separately. If tax is included in the price the tax portion is not shown > on the invoice. Taxes are only calculated if the customer/vendor is > taxable at the same rate as the item. So, if a customer is taxable at VAT > @ 10% and the item is set taxable at VAT @ 30% no taxes will be > calculated. You must also indicate that the customer is taxable at VAT @ > 30%. > > Taxes are calculated differently if included in price or shown on top. > i.e. $100 item, taxable at 7% > tax included -> net price is 93.46, tax portion is 6.54 > tax on top -> net price is 100.00, tax is 7.00 > > multiple taxes are always additive and not calculated tax on tax. > So, the same $100 item at 7% and 8% > tax included -> net price is 86.96, tax is 13.04 > tax on top -> net price is 100.00, tax is 15.00 > > > 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 =========== > > > |
|
From: Jess <je...@oz...> - 2001-05-30 06:29:33
|
Hi People,
Could some kind sole send me the following in a tar or zip file from a
working system, Please?
The whole directory under:
sql-ledger/bin
And these individual files.
sql-ledger/admin.pl
sql-ledger/login.pl
sql-ledger/sql-ledger.conf
Where is setup/pl supposed to be, on what I have it is in the
"sql-ledger/bin" is this right?
Thankyou to those who can help.
I can't believe how much trouble I am having getting this to run.
I had no problem with the 1.2.* versions.
Regards Jess
|
|
From: Dieter S. <dsi...@sq...> - 2001-05-30 17:52:29
|
Version 1.4.4 is tarred up from a working system. All you need to do is ungzip/untar, move the sql-ledger directory to your cgi-bin directory, read the FAQ and the files in the doc directory and follow the instruction. 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 Wed, 30 May 2001, Jess wrote: > Hi People, > Could some kind sole send me the following in a tar or zip file from a > working system, Please? > > The whole directory under: > sql-ledger/bin > > And these individual files. > sql-ledger/admin.pl > sql-ledger/login.pl > sql-ledger/sql-ledger.conf > > > Where is setup/pl supposed to be, on what I have it is in the > "sql-ledger/bin" is this right? > > Thankyou to those who can help. > > I can't believe how much trouble I am having getting this to run. > I had no problem with the 1.2.* versions. > > Regards Jess > > > |
|
From: Andre F. M. <and...@te...> - 2001-06-02 22:43:10
|
Hello, Dieter: I just had send out messages to many brazilian linux lists asking for=20 accountant help and found your message below. Here, in Brazil, we have a real tax hell. We have TAXES ON TAXES at different points of price setup process,=20 feeding multiple taxes accounts to balance at month end. I am not an accountant, so I can not explain right this complex subject.= =20 But in order to other people help to customize tables, sql-ledger will=20 have to allow multiple taxes on taxes, included and on top, at different= =20 points of price. Two significant taxes here: IPI is "on top", aaaaaaannnnnd ICMS "is=20 included". And they are only two of many, many other taxes, some included, other on= =20 top of others! Cascading taxes!!!=20 And these taxes depends on WHAT product or service is to be invoiced. Please, are there other brazilian people in this list? Any accountant to help? Many thanks. Andre Felipe Machado >>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<< No dia 28/05/01, 13:58:06, Dieter Simader <dsi...@sq...>=20 escreveu o seguinte sobre o tema About Taxes: > Taxes are calculated differently if included in price or shown on top.= > i.e. $100 item, taxable at 7% > tax included -> net price is 93.46, tax portion is 6.54 > tax on top -> net price is 100.00, tax is 7.00 > multiple taxes are always additive and not calculated tax on tax. > So, the same $100 item at 7% and 8% > tax included -> net price is 86.96, tax is 13.04 > tax on top -> net price is 100.00, tax is 15.00 |
|
From: Dieter S. <dsi...@sq...> - 2001-06-04 22:08:54
|
Tax on tax can be managed by adding the tax to the tax. i.e first tax @ 7% second tax @ 8% 8% would effectively be 8.56% If taxes are tax on tax as well as tax included you'll have to adjust the tax rates accordingly. Tax included applies to all taxes and not just one or the other. 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 Sat, 2 Jun 2001, Andre Felipe Machado wrote: > Hello, Dieter: > I just had send out messages to many brazilian linux lists asking for > accountant help and found your message below. > > Here, in Brazil, we have a real tax hell. > We have TAXES ON TAXES at different points of price setup process, > feeding multiple taxes accounts to balance at month end. > > I am not an accountant, so I can not explain right this complex subject. > But in order to other people help to customize tables, sql-ledger will > have to allow multiple taxes on taxes, included and on top, at different > points of price. > > Two significant taxes here: IPI is "on top", aaaaaaannnnnd ICMS "is > included". > And they are only two of many, many other taxes, some included, other on > top of others! > Cascading taxes!!! > And these taxes depends on WHAT product or service is to be invoiced. > > Please, are there other brazilian people in this list? > Any accountant to help? > Many thanks. > Andre Felipe Machado > > > > >>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<< > > No dia 28/05/01, 13:58:06, Dieter Simader <dsi...@sq...> > escreveu o seguinte sobre o tema About Taxes: > > > > Taxes are calculated differently if included in price or shown on top. > > i.e. $100 item, taxable at 7% > > tax included -> net price is 93.46, tax portion is 6.54 > > tax on top -> net price is 100.00, tax is 7.00 > > > multiple taxes are always additive and not calculated tax on tax. > > So, the same $100 item at 7% and 8% > > tax included -> net price is 86.96, tax is 13.04 > > tax on top -> net price is 100.00, tax is 15.00 > > > |
|
From: Andre F. M. <and...@te...> - 2001-06-05 15:46:42
|
Hello, Dieter: Many thanks for your answer. As I am not an accountant, I will "try" to explain the insane complexity= . In Brasil, until yesterday, we suffer 57 different taxes (help!), at=20 city, state, country level. Not all of them apply to all products or services. The ones that apply to a certain product or service, must be applied at = an exact order. Lets say,=20 value 1 =3D cost with tax 1 and tax 2 included. Value 2 =3D value1 + tax 3 on top. Value 3 =3D value 2 with tax 3 and tax 4 included. Value 4 =3D value 3 + tax 5 on top value 5 =3D value 4 + tax 6 on top etc, etc, etc.... Final price =3D value x + tax y on top (or included). They apply tax on tax, included and on top at a fixed sequence for each = kind of product or service. Each tax must have an account, with closed balance at fiscal month end. When a component is purchased, all applied taxes go to a tax account. When the product is finished product is selled, the suitable applied=20 taxes go to the taxes account. Each tax have a balance sheet. At fiscal month end, we all have to pay the tax balance dues.... Is there an easier way to configure this tax nightmare? This tax adjust seems to be very error prone... Any help from a brazilian accountant here? Many thanks Andr=E9 Felipe >>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<< No dia 04/06/01, 16:22:42, Dieter Simader <dsi...@sq...>=20 escreveu o seguinte sobre o tema Re: NEED taxes on taxes here : > Tax on tax can be managed by adding the tax to the tax. > i.e first tax @ 7% second tax @ 8% > 8% would effectively be 8.56% > If taxes are tax on tax as well as tax included you'll have to adjust = the > tax rates accordingly. > Tax included applies to all taxes and not just one or the other. > Dieter Simader http://www.sql-ledger.org (780) 472-8161 > DWS Systems Inc. Accounting Software Fax: 478-5281 |
|
From: Michael B. <Mi...@di...> - 2001-06-16 21:39:02
|
Hi Dieter: Just following up our previous e-mail posts, it appears that when posting receipts under the Receipts menu they are not posting to the acc_trans table. We are selecting all open receipts under the Receipts menu and then getting the results back. Next, entering in the amounts from the payment received (note: not all payments may have been received) we click on Process Receipts. No errors messages appear and all looks good. However, when you go to Account 1061 in the Account List and search for receipts for the date you received them on there are no transactions. I have viewed the acc_trans table for the transactions and they are not there. To further confirm this issue, the Checking Account 1061 balance does not change. Another note, the acc_trans table will be update if you edit an invoice payment amount to 0 and then put the amount back. However, the payment date is the date of the invoice. Any quick ideas on how to track down and solve this issue? It did not appear until upgrading from 1.2.9 to 1.4.3. It is still happening on 1.4.5. Regards, Michael Bush -- Digital Minds International http://www.DigitalMinds.net Tel: 615-661-7900 Fax: 615-661-7949 |
|
From: Michael B. <Mi...@di...> - 2001-06-17 02:27:27
|
Hi Everyone: Does anyone know where in the SQL-Ledger AR code (i.e. filename, line number) the receipts posting is done so I might track down my issue below? Sorry, I am a little rusty on Perl coding and the program flow of SQL-Ledger. Thanks in advance. Michael Bush -- Digital Minds International http://www.DigitalMinds.net Tel: 615-661-7900 Fax: 615-661-7949 > Hi Dieter: > > Just following up our previous e-mail posts, it appears that when > posting receipts under the Receipts menu they are not posting to the > acc_trans table. > > We are selecting all open receipts under the Receipts menu and then > getting the results back. Next, entering in the amounts from the > payment received (note: not all payments may have been received) we > click on Process Receipts. No errors messages appear and all looks > good. However, when you go to Account 1061 in the Account List and > search for receipts for the date you received them on there are no > transactions. I have viewed the acc_trans table for the transactions > and they are not there. To further confirm this issue, the Checking > Account 1061 balance does not change. > > Another note, the acc_trans table will be update if you edit an invoice > payment amount to 0 and then put the amount back. However, the payment > date is the date of the invoice. > > Any quick ideas on how to track down and solve this issue? It did not > appear until upgrading from 1.2.9 to 1.4.3. It is still happening on > 1.4.5. > > Regards, > > Michael Bush > -- > Digital Minds International > http://www.DigitalMinds.net > Tel: 615-661-7900 > Fax: 615-661-7949 |
|
From: Benjamin L. <ben...@co...> - 2001-06-18 15:41:56
|
I'm no authority on the code, although I have poked around a bit. ;-) Firstly, I've honestly never seen this bug before. Secondly, I suggest turning on the debugging of your SQL server (e.g. Postgresql) and watch the SQL statements that are logged when you click 'Process Receipts'... this will definitely show you where the problem is. On Sat, Jun 16, 2001 at 09:29:07PM -0500, Michael Bush wrote: > Hi Everyone: > > Does anyone know where in the SQL-Ledger AR code (i.e. filename, line > number) the receipts posting is done so I might track down my issue below? > Sorry, I am a little rusty on Perl coding and the program flow of > SQL-Ledger. > > Thanks in advance. > > Michael Bush > -- > Digital Minds International > http://www.DigitalMinds.net > Tel: 615-661-7900 > Fax: 615-661-7949 > > > Hi Dieter: > > > > Just following up our previous e-mail posts, it appears that when > > posting receipts under the Receipts menu they are not posting to the > > acc_trans table. > > > > We are selecting all open receipts under the Receipts menu and then > > getting the results back. Next, entering in the amounts from the > > payment received (note: not all payments may have been received) we > > click on Process Receipts. No errors messages appear and all looks > > good. However, when you go to Account 1061 in the Account List and > > search for receipts for the date you received them on there are no > > transactions. I have viewed the acc_trans table for the transactions > > and they are not there. To further confirm this issue, the Checking > > Account 1061 balance does not change. > > > > Another note, the acc_trans table will be update if you edit an invoice > > payment amount to 0 and then put the amount back. However, the payment > > date is the date of the invoice. > > > > Any quick ideas on how to track down and solve this issue? It did not > > appear until upgrading from 1.2.9 to 1.4.3. It is still happening on > > 1.4.5. > > > > Regards, > > > > Michael Bush > > -- > > Digital Minds International > > http://www.DigitalMinds.net > > Tel: 615-661-7900 > > Fax: 615-661-7949 > > > > -- B. http://makelinux.org/ "Always real." http://realthought.net/ __________________________________________________________________________ The trouble with telling a good story is that it invariably reminds the other fellow of a dull one. -- Sid Caesar |
|
From: Dieter S. <dsi...@sq...> - 2001-06-17 22:36:46
|
The date bug was introduced when we added the trial balance. The balances didn't zero out when the original AP/AR amounts were reduced by the amount of the payment so I basically recorded the payment date as the invoice date. It's all fixed now in version 1.4.6 Instead of reducing the original AR/AP amount an offsetting transaction is added to keep the balance zero. When you edit the original transaction and enter a payment the payment date is assumed to be the invoice date. The only deviation you could possibly have is when you accept a postdated check for payment. 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 Sat, 16 Jun 2001, Michael Bush wrote: > Hi Dieter: > > Just following up our previous e-mail posts, it appears that when posting > receipts under the Receipts menu they are not posting to the acc_trans > table. > > We are selecting all open receipts under the Receipts menu and then getting > the results back. Next, entering in the amounts from the payment received > (note: not all payments may have been received) we click on Process > Receipts. No errors messages appear and all looks good. However, when you > go to Account 1061 in the Account List and search for receipts for the date > you received them on there are no transactions. I have viewed the acc_trans > table for the transactions and they are not there. To further confirm this > issue, the Checking Account 1061 balance does not change. > > Another note, the acc_trans table will be update if you edit an invoice > payment amount to 0 and then put the amount back. However, the payment date > is the date of the invoice. > > Any quick ideas on how to track down and solve this issue? It did not > appear until upgrading from 1.2.9 to 1.4.3. It is still happening on 1.4.5. > > Regards, > > Michael Bush > |
|
From: Jess <je...@oz...> - 2001-06-09 15:01:19
|
Hi Dieter, Just to make this clear straight of the bat prior to version 1.4 of SQL-Ledger I had no problems running SQL-Ledger in the 1.2.* variety. I clean installed SQL ledger. Now I cleaned out all the SQL tables and downloaded SQL-Ledger 1.4.4 from your Web Site unpacked it and recreated the tables from the acc-PG.sql file. I removed any traces of the previous SQL-LEDGER 1.2.* which was working. I then move the SQL-Ledger directory with the login.pl and sql-ledger.conf file and all subdirectories to the web document root called /www/websites/bookmen/sqll I also created any directories that where called in the sql-ledger.conf file so that it could find anything it was looking for. I read the FAQ and the README and it said to: SETUP A USER: ------------- Load your web browser and enter the URL http://localhost/cgi-bin/sql-ledger/admin.pl and add a user. If you specify a different database then the one you just created in the previous step, make sure the database and tables exist. (see previous step) LOAD THE ACCOUNTING PROGRAM: ---------------------------- Load your web browser and enter the URL http://localhost/cgi-bin/sql-ledger/login.pl Now there is no http://localhost/cgi-bin/sql-ledger/admin.pl in that directory there is only login.pl and am.pl If I open the admin.pl in the "bin/mozilla" directory the is no shebang line or "require" command for the .conf file on any of these files which leads me to believe that these files are read into a calling .pl file probably login.pl. How do you add or create a user? What .pl file in what directory needs to be run and what needs to be entered in the Browser URL to call it? There is something fundamental I am not aware of that must be causing these problems? Your assistence is needed. SQL Ledger is being run on W2K Pro with PG 703 and perl5, apache 1.3.14. Regards Jess ----- Original Message ----- From: "Dieter Simader" <dsi...@sq...> To: <sql...@li...> Sent: Tuesday, 05 June, 2001 5:22 AM Subject: Re: NEED taxes on taxes here > Tax on tax can be managed by adding the tax to the tax. > > i.e first tax @ 7% second tax @ 8% > 8% would effectively be 8.56% > > If taxes are tax on tax as well as tax included you'll have to adjust the > tax rates accordingly. > > Tax included applies to all taxes and not just one or the other. > > > 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 Sat, 2 Jun 2001, Andre Felipe Machado wrote: > > > Hello, Dieter: > > I just had send out messages to many brazilian linux lists asking for > > accountant help and found your message below. > > > > Here, in Brazil, we have a real tax hell. > > We have TAXES ON TAXES at different points of price setup process, > > feeding multiple taxes accounts to balance at month end. > > > > I am not an accountant, so I can not explain right this complex subject. > > But in order to other people help to customize tables, sql-ledger will > > have to allow multiple taxes on taxes, included and on top, at different > > points of price. > > > > Two significant taxes here: IPI is "on top", aaaaaaannnnnd ICMS "is > > included". > > And they are only two of many, many other taxes, some included, other on > > top of others! > > Cascading taxes!!! > > And these taxes depends on WHAT product or service is to be invoiced. > > > > Please, are there other brazilian people in this list? > > Any accountant to help? > > Many thanks. > > Andre Felipe Machado > > > > > > > > >>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<< > > > > No dia 28/05/01, 13:58:06, Dieter Simader <dsi...@sq...> > > escreveu o seguinte sobre o tema About Taxes: > > > > > > > Taxes are calculated differently if included in price or shown on top. > > > i.e. $100 item, taxable at 7% > > > tax included -> net price is 93.46, tax portion is 6.54 > > > tax on top -> net price is 100.00, tax is 7.00 > > > > > multiple taxes are always additive and not calculated tax on tax. > > > So, the same $100 item at 7% and 8% > > > tax included -> net price is 86.96, tax is 13.04 > > > tax on top -> net price is 100.00, tax is 15.00 > > > > > > > > > > > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X