# Billing

**URL:** <https://www.protaxcommunity.com/t/billing/1649>\
**Category:** T1\
**Created:** [March 6, 2018, 7:12am UTC](https://www.protaxcommunity.com/t/billing/1649 "2018-03-06T07:12:23Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![slim](https://avatars.discourse-cdn.com/v4/letter/s/b5e925/32.png) [@slim](https://www.protaxcommunity.com/u/slim)\
**Post date:** [March 6, 2018, 7:12am UTC](https://www.protaxcommunity.com/t/billing/1649/1 "2018-03-06T07:12:23Z")

</div>

Could you pls add a line in the Billing worksheet for the amount after taxes as well, so we can post  
the amount onto Sch 4 if applies.

Otherwise have to calc the tax component on to the amount

Both amounts before and after taxes would be helpful

thx

---

<div class="post-metadata">

**Author:** ![Rob](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/rob/32/781_2.png) [@Rob](https://www.protaxcommunity.com/u/Rob)\
**Post date:** [March 6, 2018, 9:27pm UTC](https://www.protaxcommunity.com/t/billing/1649/2 "2018-03-06T21:27:44Z")

</div>

Hi,

We have added the prior year total after tax to the Prior year area of the billing worksheet. Look for it in our next release.

~ Rob

---

<div class="post-metadata">

**Author:** ![kozakworld](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/kozakworld/32/1594_2.png) [@kozakworld](https://www.protaxcommunity.com/u/kozakworld)\
**Post date:** [February 22, 2021, 7:58pm UTC](https://www.protaxcommunity.com/t/billing/1649/3 "2021-02-22T19:58:36Z")

</div>

On the Billing Worksheet, I occasionally have fees that I want to override and not charge some clients. With profile, I would simply override the amount and the line wouldn’t show up on the Invoice. This does not work in TaxCycle, as it then shows the line with the fee left blank. If I delete the row, it wants to re-create it. If I override the entire row, I get a blank row on the invoice.

Is there a way to overcome this issue without having to remove the fee from the Fee schedule in Setup? The only other option I can think of is to record a Discount to remove the fees that I don’t want to charge.

Also, sorting the Fees in the worksheet … the options are Ascending or Descending.  
I wish there was an option to restore default sorting, because as soon as they are sorted, the T1 Federal jacket gets moved out of the top position and now I have to manually move it back up.

I much prefer Profile’s billing system over TaxCycle. It will take a while to adjust, or I switch to using Quickbooks for my billing.

---

<div class="post-metadata">

**Author:** ![Arliss](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/arliss/32/52_2.png) [@Arliss](https://www.protaxcommunity.com/u/Arliss)\
**Post date:** [February 22, 2021, 8:13pm UTC](https://www.protaxcommunity.com/t/billing/1649/4 "2021-02-22T20:13:22Z")

</div>

Everybody loves a discount. 😀

---

<div class="post-metadata">

**Author:** ![Cameron](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/cameron/32/12_2.png) [@Cameron](https://www.protaxcommunity.com/u/Cameron)\
**Post date:** [February 22, 2021, 11:15pm UTC](https://www.protaxcommunity.com/t/billing/1649/5 "2021-02-22T23:15:33Z")

</div>

If you want the line to hide when the amount is zero, you can change the logic that shows the line in the invoice template.

The reason we do this is that some of our preparers want to show all the lines because it shows work that has been done, even if no fee was charge for preparing that form…

Here’s the change I’m talking about, highlighted in yellow

 ![image](https://us1.discourse-cdn.com/flex016/uploads/taxcycle/original/2X/e/e1b812775b35af70f84b8dc317c1d19cd64ce559.png)

---

<div class="post-metadata">

**Author:** ![kozakworld](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/kozakworld/32/1594_2.png) [@kozakworld](https://www.protaxcommunity.com/u/kozakworld)\
**Post date:** [February 23, 2021, 4:49am UTC](https://www.protaxcommunity.com/t/billing/1649/6 "2021-02-23T04:49:39Z")

</div>

Thank you, Cameron.  
Appreciate that tip. Very helpful. I hadn’t thought to check if there was a template for the worksheet.  
I played with it briefly but the code placement you suggested didn’t work. I’ll play with it later when I have more time.

What is the Mustache code to enter a Carriage Return?  
The Billing Worksheet “Description of Services” doesn’t use carriage returns between different lines. In contrast I prefer using carriage returns for each new item in that description vs using paragraph format. Is this possible?

---

<div class="post-metadata">

**Author:** ![CGLtax](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/cgltax/32/1939_2.png) [@CGLtax](https://www.protaxcommunity.com/u/CGLtax)\
**Post date:** [February 15, 2023, 7:45pm UTC](https://www.protaxcommunity.com/t/billing/1649/7 "2023-02-15T19:45:02Z")

</div>

@Cameron - this was helpful (I used a higher threshold than 0 to focus on the important ones while still pricing the smaller ones) … however…

I’m wondering if there is a way to manually sort the line items either in the Price List options, or on the Billing Worksheet other than “Descending” or “Ascending”.

For example, we would like the T1 to show above AB428 - which it does at first. But when we try to rearrange anything, then it limits our options. We currently show the {{Form}} and {{Details}} … but we would like to rearrange the layout of the Billing Worksheet so the items are in a specific order.

Idea: perhaps allowing us to assign a Ranking Number on the Billing Worksheet, then sort by that? I originally tried it with a bunch of price overrides, but it defeats the purpose of the price list.

Idea 2: Insert a “Rank” column in the price list, so you can sort how they show up on the Billing Worksheet

---

<div class="post-metadata">

**Author:** ![jglass](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/jglass/32/723_2.png) [@jglass](https://www.protaxcommunity.com/u/jglass)\
**Post date:** [February 16, 2023, 7:25pm UTC](https://www.protaxcommunity.com/t/billing/1649/8 "2023-02-16T19:25:52Z")

</div>

Another option is to take the line item pricing out of the Invoice template entirely. Our invoices show each line item, but then only show the total (plus admin fee, minus discounts, plus tax).

---

<div class="post-metadata">

**Author:** ![Arliss](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/arliss/32/52_2.png) [@Arliss](https://www.protaxcommunity.com/u/Arliss)\
**Post date:** [February 16, 2023, 8:03pm UTC](https://www.protaxcommunity.com/t/billing/1649/9 "2023-02-16T20:03:04Z")

</div>

I have always just not shown the details of schedule charges but I like this idea.

I wonder if that could be incorporated into the coding and billing worksheet by Taxcycle?

Seperate choice for “Show details of schedule **charges** on client invoice?” and “Show details of schedule **items** on client invoice?”

---

<div class="post-metadata">

**Author:** ![CGLtax](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/cgltax/32/1939_2.png) [@CGLtax](https://www.protaxcommunity.com/u/CGLtax)\
**Post date:** [March 19, 2023, 10:23pm UTC](https://www.protaxcommunity.com/t/billing/1649/10 "2023-03-19T22:23:44Z")

</div>

@Arliss we used the visibility formula that @Cameron suggested so only fees that are over a certain threshold show up. Also, in our template, we actually removed the price column from the schedule - so that way it prints the listing, of amounts over a threshold, but only shows the total fee - not a breakdown.

For example, anything that hits $20 (just for presentation purposes - not the actual fee) shows up - only one kid - nothing… but 4 kids… that’ll show up. In this example, we override the actual fee.

 ![Billing Worksheet](https://us1.discourse-cdn.com/flex016/uploads/taxcycle/original/2X/a/ae6df0ea3f84c5b8bc2f4091c237b6496c63247a.png)

The result of our template using the $20 threshold instead of $0 … and by deleting the part that shows the fee in the list, (using our code below) results in just the summary.

CODE:

 ![Snippet](https://us1.discourse-cdn.com/flex016/uploads/taxcycle/original/2X/8/84e171e5cce5f1d32313ca00ef36fe8df8bd4bca.png)

Result of all of the above:

 ![Result](https://us1.discourse-cdn.com/flex016/uploads/taxcycle/original/2X/c/ced9c8130c54f6b10c1e405df48fc4b6005e127a.png)

But, you can see how the ordering of the items has no rhyme or reason to the sequence - which is why I would like to see a Ranking column that you can program or edit manually.

---

<div class="post-metadata">

**Author:** ![CGLtax](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/cgltax/32/1939_2.png) [@CGLtax](https://www.protaxcommunity.com/u/CGLtax)\
**Post date:** [March 19, 2023, 10:38pm UTC](https://www.protaxcommunity.com/t/billing/1649/11 "2023-03-19T22:38:57Z")

</div>

Yes we do that too… but if you look at my example further down - the issue is that it looks messy. There is no structure to the listing.

---

<div class="post-metadata">

**Author:** ![jglass](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/jglass/32/723_2.png) [@jglass](https://www.protaxcommunity.com/u/jglass)\
**Post date:** [March 19, 2023, 11:58pm UTC](https://www.protaxcommunity.com/t/billing/1649/12 "2023-03-19T23:58:14Z")

</div>

Not as clean a solution, but if you delete an item off the billing worksheet it drops down to the bottom of the list, so if this was important enough you could delete things in the order you want to have them show up in order.

But I think most of my clients won’t read the invoice in this much detail so I mostly don’t bother.
