1. Home
  2. Docs
  3. WGits for Quickbooks Desktop
  4. How Do I Record my Tax Payable Accounts?

How Do I Record my Tax Payable Accounts?

  • User Guide Search

You need to be able to record your Taxes to be remitted quickly and easily, especially if you are paying Taxes monthly. WGits QB records your sales in just one “Other Charge” item for your Sales Taxes. We don’t use Sales Tax Items for recording your taxes because it’s typically not dynamic enough for the adult beverage industry.

The item that we map your Sales Taxes to will map to your Sales Tax Payable account. Then once a month or once a quarter, you’ll be able to record a single journal entry to map the amount of taxes you’ve charged to each state. This journal entry would be to move sales from your single Sales Tax Payable account and migrate the proper amounts to each Liability Account for each unique state and county.

Below is a list of various reports to access in order to easily record your Taxes based on your eCommerce platform.

Commerce7

eCELLAR

VineSpring

VinSUITE

WineDirect


Commerce7:

In Commerce7, go to Reports > Order Reports > Sales By Ship Country / State.

accessing tax by state report in Commerce7

Here you can quickly see summaries of your various states tax totals collected. County breakdowns are not possible with this report, but it’s possible with ShipCompliant to identify which counties you charged taxes to.

Sales Tax Report in C7

eCELLAR:

Go to the Reports menu Icon > Company Reports > On the right hand side you’ll see the Report Category drop down. Choose the Finance option, then the Sales Tax by City Report. This will breakdown all your counties for you easily.

ecellar report to display tax county breakdown

VineSpring:

Go to Reports > Sales Dashboard > Sales Pivot Tables.

VineSpring - Dashboard Reporting

VineSpring Sales Pivot Table Options

VineSpring Pivot Table showing taxes

VinSUITE:

In VinSUITE, go to Reports > Report Builder. Build a new report with the Base of Sales Summary, and name it Sales Summary Tax or whatever name you wish to give it.

vinsuite report builder

Next customize the report columns by dragging and dropping the appropriate columns into the Chosen Sorted Fields section.

editing the sales summary tax report

Next, ensure the filters look like this:

vinsuite editing the report for taxes

Save and Run (in the future) you can simply edit the report by just changing the filter data to look for orders Greater than or Equal to, the first day of the month you wish to pull a report for:

vinsuite report editing and preparing to download it

The end result is an excel file that looks like this.

Select the entire sheet and activate the filters. Then you can filter by state, and by county and quickly select the tax column. This helps you to determine the tax totals by state and for states that require county breakdowns, this information is automatically populated in the ShippingCounty column whenever possible by VinSUITE.

excel formatting for easily reporting taxes

Here is a brief clip of how to filter the downloaded file:
gif on how to filter excel for the tax report in vinsuite

WineDirect:

In WineDirect, go to Reports > Sales Reports > Sales Summary by State. This report will allow you to see a summarized total of taxes per state.

This does not provide you county breakdowns. Alternatively you are able to collect county breakdowns thanks to ShipCompliant with a ShipCompliant account.

winedirect report for tax totals