Issue: “Tax Account” and “Tax/Base Amount” missing in reconcile window.

[[e-mail]]

When reconciling in entries by statement sometimes a write-off needs to be made.
This write-off might be tax relevant. For example I need to write off 107.60 in
total of which 100.00 goes against account sales and 7.60 go against account VAT
when the VAT is 7.6%. The write off may look as follows in the case of our system:
Account Amount Description
3010 Erlös Sport Inland 100.00 Skonto (2%)
2230 Kreditoren VAT 7.60 Skonto (2% )

That’s fine for the financial accounting. However, the tax system is wrong because
the field “Tax Account” and “Tax/Base Amount” are empty. The fields are missing in
the form. The write-off in recon needs to look like the following:
Account Amount Description “Tax Account” “Tax/Base Amount”
3010 Erlös Sport Inland 100.00 Skonto (2%) B_USt_7.6 -100
2230 Kreditoren VAT 7.60 Skonto (2%) T_USt_7.6 -7.6

The recon with write off in financial management>Periodical
Processing>Reconciliation>Reconcile Entries, Action Reconcile Entries is even more
problematic because it only allows for one single write off line. So write-offs
where taxes are involved are not possible. It should allow multiple lines for write
off including fields for tax account and tax amount as described above.

Alternative solution: The better way of doing it is obviously to use the structure
of invoice lines in the write-off section of the reconciliation window. This way the
user can enter only one line and doesn’t need to calculate the split between actual
sum and connected tax amount manually. The user would just add one or many taxes to
each write off line just as he does in invoice lines. The system can then deal with
choosing the correct Tax Account and calculating the Tax/Base Amount. This would as
far as I can see always have to operate in a “taxes included in price” mode.

Example for recon write-off with alternative solution:

Writeoff-Line (identical to invoice line)
Description Account Amount Taxes Incl. Taxes
Skonto (2%) 3010 Erlös Sport Inland 107.60 yes-tick Umsatzsteuer 7.6%

Button: Compute Taxes

Taxes
Taxes Description Base Amount
Umsatzsteuer 7.6% 100.00 7.6

Let’s do the first solution as it is faster to implement. May be the other solution
is worth a blueprint. What do you think? There are actually a lot of unanswered help
cries about this issue on the forum (most of them german speaking).