Transactions report - all info in one line per transaction (not a second PST line)
Report for "Account Transactions" should only produce one line per transaction.
Currently, the report splits off a separate line for the PST component of each transaction, adding "- PST" in the description and to the contact name, and pulls the PST amount out of "Gross".
I need an account transaction report that includes GST, PST and the unit price in "gross" on a single line per transaction. These gross values will match the bank statement, and have the description/reference/contact and the account(s) the transaction was coded to.
The easiest approach is to have additional columns to select from, and (critically) only one line per transaction. Columns could be: "Gross", "PST", "GST", "Net" ... so if a purchase was made on $100 with 5% GST and 7% PST, the line would look like:
Date / Purchased Item / $112 Gross / $7 PST / $5 GST / $100 Net / Description / Contact / etc.
Currently, to get that kind of report, I need to export a CSV and use spreadsheet magic to isolate out the PST lines, and then add the PST back into the "gross"!
Andrew Bennett
shared this idea
-
alot ubvid
commented
To generate an Account Transactions report that displays all information in a single line per transaction, you should configure the report to include separate columns for "Gross," "PST," "GST," and "Net" while ensuring no additional PST lines are split off. Each transaction line should consolidate all tax components and unit prices so that the "Gross" column reflects the total amount including taxes, matching the bank statement, and other columns clearly show PST, GST, and net amounts. The report should also include the full description, reference, contact, and account coding for clarity. For example, a $100 purchase with 5% GST and 7% PST would appear as: Date / Purchased Item / $112 Gross / $7 PST / $5 GST / $100 Net / Description / Contact / Account, all on a single line. This approach removes the need for manual CSV adjustments and spreadsheet work to combine PST lines, making transaction tracking simpler and more accurate—similar to how a streamlined service like AC Cleaning Dubai https://accleaningdubai.net/ presents all service details clearly in one place.
-
Przemek Cerazy
commented
This PST issue has been bothering me for a while.
PST is also treated very strangely in the Projects module. If you assign an expense to Projects, only the pre-tax amount will be linked. When you are billing the expenses to a customer, you miss out on the PST as it is not tagged to the Project.
I wonder if this could be an easy fix - add a function under sales tax, similar to GST, where you can make it recoverable or not.