By adding fees to individual orders, it can be easier to reconcile. We recommend adding expenses in bulk when you match deposits. Adding expenses to orders will incorrectly record sales tax liability, therefore, you cannot use QB to track sales tax payable in some tax jurisdictions. Talk to your CPA prior to adding expenses to individual orders.
How do I add fees per order?
Here are the steps:
- On the Cloud Cart configure page, click the transaction tab.
- Scroll down to advanced fee settings. If the section is missing, click the advanced tab.
- Enter the item in QB, the percent and the cents to add on top of the fees. In this example, we will add 2.9% of the order plus thirty cents:
How do I change the fee percent, based on the payment method?
Under turn on fees, add a default percent as a catch-all. In that example, all orders except the ones with the rule will be 2.5%. To change the percent, you must add a rule:
- In Cloud Cart, hover over the gear and click rules engine.
- Click add new rule.
- For each payment method, add a rule like this one:
- Out of box, Cloud will use a single item for fees. The field is under advanced fee settings. You can use a different item name for different fee types. In this example, we will use merchant fees for all fees except PayPal:
How do I change the merchant percent, based on the billing address country?
The rule is the same as the payment method, except the field is order billing address country. Replace map to with the two letter abbreviation of the country.
How do I remove fees from certain payment methods, like PayPal?
In the advanced fee settings, enter zero as the fee percent and fee cents. You must add a mapping for each payment method that includes the percent and fees to add. In this example, we will add 2.9% plus thirty cents for PayPal:
How should expenses be entered?
You should add expenses as a bill and payment in QuickBooks, if you get a bill. Go to vendors and select a vendor. Click new > bill. Create a payment.
You can enter credit card fees in the bank deposits area > add new deposits area as a negative number, if orders go into bank deposits.
What happens if I enter fees per order?
Here is an order from QB with credit card fees. The fees credit the Cost of Goods Sold account:
The profit and loss looks fine:
This is a sales tax liability report. The gross sales should say $100 instead of $97.10:
You must report your gross sales, taxable and non taxable sales to the state & municipal taxing agencies using another method.