What is a Supplier Bill?

Supplier bills show the amount owed for an order's goods and services. You can add your supplier bills to commonsku to capture an order's costs, calculate the Billed Margin and your sales rep's commissions.

On this page:

Bill overview

FAQ

Bill overview

Supplier bills show the costs payable to the suppliers, decorators, and any other parties (i.e., UPS) that have provided a good or service on your order.

Once you receive a bill from your supplier, you can add it to your:

Users need permission to Create/Modify/Delete Bills to adjust bills in commonsku.

You can create:

commonsku Tip: Make sure to export your bills to your accounting software so you can keep track of your accounts payable and make payments as required.

Entering your bills is necessary for calculating your commissions.

Commissions are calculated on a per-project basis, based on the subtotal from the client's invoice(s) and costs from the supplier bills (Billed Margin). 

[Back to top]

FAQ

How do I delete a bill?

To delete a bill, you will need to head into Finance > Billing:

  1. Click the "Report Type" drop-down, select Export Bills or Exported Bills
  2. Select a supplier, enter a PO number, or add the bill's dates
  3. Click Get Report
  4. Select the bill(s) you'd like to delete
  5. Click Delete Selected
  6. In the "Are you sure you want to delete these bills?" pop-up, click OK

You cannot recover a deleted bill. If you accidentally delete a bill, you'll need to manually re-add it.

How do I mark a PO as billed?

To mark a PO as billed:

  1. In the Bills tab, under the "All Bills Received" column, select the checkbox beside the PO you'd like to mark as billed

c2b93807-7277-4347-af29-527f5276f1db

Marking a PO as billed does not affect the project's booked margin or commissions.

How do I export a bill?

Depending on your process, you can export bills as a CSV or XML file, export to Quickbooks Online, export to Xero, or import bills into Quickbooks Desktop

How do I reexport a bill?

To reexport bills to QuickBooks Online, Xero, or your custom webhook:

  1. Go to Finance > Billing > Report Type: Exported Bills
  2. Use the filters to narrow your search, then click the Get Report button and locate the bill(s) you need to reexport
  3. When you've found the bill(s), select the radio (checkbox) on the left side of the invoice number(s)
  4. Click the UnExport Selected button > then, click OK
  5. Go to Report Type: Export Bills
  6. Use the filters to narrow your search, then click the Get Report button and locate the bill(s) you need to reexport
  7. When you've found the bill(s), select the radio (checkbox) on the left side of the invoice number(s) and click the Export to button

Exported bills automatically transfer to the Finance > Billing > Exported Bills Report. 

Be sure to delete the existing bill from accounting before you reexport it.

How can I remove a bill from the export list when not exporting to my accounting platform

To remove a bill from your export list:

  1. Set your invoices/bills to export as CSV or XML files
  2. Export the invoices/bills as normal
  3. Set your invoices/bills to export back to your accounting platform

How do I process pre-payments?

If a bill is prepaid:

  1. Log the prepayment as an unapplied payment on the supplier profile in your accounting platform
  2. In commonsku, indicate the pre-payment on the bill’s memo field or add “CC” to the front of the bill number to show it is prepaid and help match it to the unapplied payment in your accounting software
  3. Export the bill as normal

How do I add a credit to a supplier bill?

You can add a discount or credit to a supplier bill in commonsku by adding a negative value service line.

To add a negative value service line:

  1. In the supplier bill, click Add Bill Item
  2. Enter the code and item name (discount or credit)
  3. Enter the amount of the discount/credit as a negative value in the unit cost field (i.e., "-10.00")
  4. Click to View/Edit Breakdown and remove the line item's tax, or change it to tax-exempt
    Add/edit the other line items (optional)
  5. Click Done

[Back to top]