Setting Up Washington Payroll In Xero

One great thing about Xero is that its payroll services are included in most plans at no additional cost.  And using Xero’s wizard, setting up payroll is fairly simple and straightforward.  But Washington, like many other states, has some payroll nuances that you’ll need to be prepared for as you run through payroll setup in Xero.

Step 1: Set Up Your Chart of Accounts For WA Payroll.

First, make sure you have at least the following accounts already set up in your chart of accounts:

Liability Accounts

  • Payroll: Wages Payable
  • Payroll: Federal Employment Tax Payable
  • Payroll: FUTA Payable
  • Payroll: WA UI Payable
  • Payroll: WA Workers Comp Payable

Expense Accounts

  • Payroll: Wages Expense
  • Payroll: Federal Employment Tax Expense
  • Payroll: FUTA Expense
  • Payroll: WA UI Expense
  • Payroll: WA Workers Comp Expense

Step 2: Set Up WA Unemployment Tax.

There are two places you’ll need to set up Washington-specific aspects of your payroll.  The first is in Settings > Payroll, and then on the “Taxes” tab.  Scroll down below the heading for “Federal (FED)” and click the down arrow next to “Washington (WA)”.  (If you don’t see Washington, that means you have not yet added a work location in Washington.  Do this on the “Work Locations” tab.)

screen-shot-2016-12-18-at-2-47-22-pm

After you click the arrow, the Washington panel will open.  Scroll down to view the entire panel:

screen-shot-2016-12-18-at-2-50-53-pm

Enter your “WA ES Reference Number.”  This is the ESD number shown in the upper right corner of your letter from the Employment Security Department setting up your ESD account:

img_3ee1c1960e35-1

Next, enter your WA UI Rate.  This is something the Employment Security Department will send you annually.  Here’s an example notice, with the WA UI Rate circled:

scan

The next field is the WA EAF rate.  That’s found on your same tax notice, here:

scan

Finally, choose your liability and expense accounts.  If you used the list we set up at the top of this post, your WA UI & Surtax Liability account will be Payroll: WA UI Payable; and your WA UI & Surtax Expense account will be Payroll: WA UI Expense.

Click save, and the UI component of your payroll is all set up!

Step 3: Set Up WA Workers Comp Deductions.

Next you’ll have to set up the second Washington-specific component of your payroll, which is the WA Workers Comp deduction.  In Washington, there are two components to the state-provided workers compensation program: (1) an employer-paid portion; and (2) an employee-paid portion.  The employer portion is not natively supported in Xero payroll, so it will require an extra calculation each time you run payroll.  The employee portion will be set up as a deduction.

To create that deduction, select the “Pay Items” tab in your Payroll Settings screen.  On the left, click “Deductions:”

screen-shot-2016-12-18-at-3-09-58-pm

To the right, click “Add,” and select “After Tax Deduction.”  A window will pop up – fill in the following:

Deduction Name: WA LNI

Standard Amount: [Leave Blank]

Company Max: [Leave Blank]

Liability Account: Payroll: WA Workers Comp Payable.

Click Add.

You’ve now set up your WA Workers Comp tax withholdings, and your Washington-specific payroll setup is complete.

Would you like help setting up your payroll?  Contact us today!

Be sure to sign up for our newsletter to get more great tips and tricks.



Reconciling Client Trust Accounts In Clio

Performing an ethics-compliant, three-way trust accounting reconciliation in Clio is easy when done correctly.

Step 1: Ensure Your Individual Clio Trust Balances Match Your Bank Statement

First, make sure you’ve received your bank statement for the month.  Reconciling with Clio works best when you receive a paper or PDF bank statement, rather than a download of transaction listings.  Using the actual bank statement, it is easier to compare balances.

Print a Trust Listing Report.  In Clio, select the tab for Reports, then click Trust Listing.  Settings for the report should be as follows:

  • Uncheck “Show clients with zero balance”
  • Select the button for “All Clients”
  • Select Practice Area: All
  • Select Date Range: Custom: Leave the start date blank, and set the end date as the date of your statement
  • Output Format: CSV
  • Click “Generate Report”

The report will automatically download, and you can typically find it in your downloads folder.  Move it to your trust reconciliation file, and save it there.  Now open it.

If you have more than one trust account, you’ll have to delete all the other trust accounts from this report, so that only the trust balances for the account you’re reconciling remain.  If you don’t have more than one trust account, skip this paragraph.  To do this, sort Column B (the Account column) A > Z.  (Place your cursor in Column B; click the Data tab; and click the screen-shot-2016-11-22-at-10-22-12-ambutton.)  Delete all lines in the spreadsheet that contain any account other than the one currently being reconciled.  Do you agree with me that it would be nice if Clio’s report feature would let us select a certain account so we don’t have to do this deletion step?  Please email them and let them know.

In Cell E1, enter the following formula: =SUM(D:D)  Hit enter.  The number Excel spits out in the cell should equal the Ending Balance on your bank statement.  When it does, the first of your three reconciliations is complete.

Step 2: Ensure Your Bank Account Activity Report Matches Your Bank Statement.

Print a Bank Account Activity Report.  In Clio, select the tab for Reports, then click Bank Account Activity.  Prepare your report with the following settings:

  • Trust Accounts: Select “Specific Account,” and choose the correct account
  • Select Practice Area: All
  • Select Date Range: Last Month (unless your bank statement doesn’t run with the calendar month, in which you’ll select “Custom” and enter the same dates as your bank statement)
  • Check the box for “Include Opening Balance”
  • Do not check the box for “Display Matter to Matter Transfer Transactions”
  • Output Format: PDF

Click “Generate Report” to download it, move it to your reconciliations folder, and open it.  Ensure that the opening balance matches the opening balance on your bank statement.  Ensure the closing balance also matches your statement.  Finally, check to ensure that all transactions showing on your bank statement appear on your report (which they should, if the opening and closing balances match).

Step 3: Ensure Your Bank Account Activity Report Balance Matches Your Trust Ledger Balance

If you’ve performed the two steps above and the ending balances match, then this step is already complete: compare the total balance on your Trust Ledger Report (which was calculated in Cell E1 in Step 1) with the ending balance in your Bank Account Activity Report.  When these two balances match, your three-way reconciliation is complete.

Not currently using Clio?  Try it for free.

Skepsis would love to perform your monthly trust reconciliations for you, whether or not you’re using Clio.  Please email email us at info@skepsistech.com.  Gain more great insights by subscribing to our newsletter below.