November 2019 Newsletter

 

Now in November: The power to choose – technology that works for YOU

  • New! Monthly installments of new products, partners, and technology. Part One of a new series.
  • Procore shares key strategies for dealing with the Subcontractor labor shortage.
  • Ruth S. lists 3 critical things you need to know every year, for Year End.
  • Mobility webinar for Sage 300 CRE and 100 CON from Core Cloud Systems (the TimberScan people).
  • Sage Intacct:  Preaccounting defined and streamlined (written by Expensify).
  • Awesome ‘Tips + Tricks’ for Accounting | Sage 300 CRE | Sage 100 CON | Sage Estimating

 


Power of Choice, Part One

by Joanie Hollabaugh | LAI Sr. Director of Marketing

software-choice

Clearly, LAI wants to be your business solution provider for life. We acknowledge that some accounting solutions we offer are, ahem, “legacy” products (perhaps because we have been selling/supporting them for over two decades).

Well, we want new choices, too! We’ve been on the search for newer, dare we say, sexier solutions for you. So as your Sage Value Added Partner, we’ve become early adopters of the most innovative, technology-forward solutions, and at the same time, supporting Sage Construction to continue improving the ‘older’ products.

We are totally on board with Sage’s new campaign, “The Power of Choice.” Simply put, you select the technology for how you want to do business. 

LAI is devoted to informing you of opportunities to move to the cloud, designing hybrid solutions, or endorsing your desire to remain totally on-premise. We’re agnostic to your technology preference — we simply want you to be prosperous and delighted with your choices. So come along for the Power of Choice ride over the next few quarters (and maybe longer), as we introduce and evaluate new products and partners as they become available to the market. And thank you, for your trust and your business.

What’s new in Products

While some things are still in development, 2020 is going to be BIG for “disruption.” This is what we can share right now. More to come each month via this newsletter. (Tell your co-workers to sign up here.)

Sage + Procore

If you attended Procore’sGroundbreak” in Phoenix in October, you could feel the love these former frenemies were exuding (Missed it? Relive it here). LAI could not be happier that these two giants have locked arms. The power of Sage 300 CRE job-based accounting integrated with Procore’s exceptional project management capabilities is a winner for all.

Sage Intacct for Construction

The ‘worst kept secret’ was officially announced at the Sage Advantage event last month – a cloud version of Intacct for Construction! Sage Intacct is a true ERP cloud platform, is GAAP compliant and AICPA’s preferred provider — and YES, we use it internally. So we know the system from the ground up. Talk about drinking your own champagne!

What does all of this mean for you?

  • If you’re an existing Procore user, it means you can connect project management data to Sage CRE financials in Sage 100 Contractor, Sage 300 CRE and next year with Sage Intacct.
  • If you’re a Sage 300 CRE client who wants the power of Procore, you don’t have to find, purchase, and migrate to a whole new accounting system.
  • If you’re ready to move from your on-premise CRE system to the cloud Sage Intacct is launching a basic GL and payroll version in Q1 2020, while continually adding more construction modules (vis a vis CRE)
  • If you’re happy with your current 100 CON or Sage 300 CRE –  these products are continuing to be enhanced and will be supported for 10+ years. Plus, there are many mobile and subscription options for you – Sage Construction Project Center, Sage Paperless, Sage Field Operations, and Sage Service Operations, to name a few.
  • Like the Salesforce model, Sage Intacct comes with an eco-system of third-party integrators which adds other cloud-based business functionalities, like tax compliance, IoT, AI, field communication and more. We will be highlighting individual ‘Marketplace Partners’ in our continuing Power of Choice installments.

When does all of this happen?

  • The Sage and Procore integration is already live for both 100 CON and 300 CRE
  • Sage Intacct for Construction will launch an early adopter release in February and general availability in May. They also do four releases per year and will be adding many features on a quarterly basis, which automatically pushes into your software.
  • Intacct and Procore integration will be available in the February release (of Intacct).

 



Key Strategies for Dealing with the Subcontractor Shortage

Reprinted by permission from Procore Jobsite. | By Duane Craig | Posted on October 28, 2019 | Original blog here.

Construction’s labor shortage continues spreading across the subcontractor landscape. The Institute for Supply Management addressed the shortage of subcontractors for the sixth consecutive month in its June 2018 Non Manufacturing Report on Business.

In particular, rough and finish carpenters, bricklayers, masons, drywall installers and concrete workers were reported seriously short in NAHB’s remodeling surveys in both 2016 and 2017. Here are tactics that will help you keep the subs you have, and to attract the ones you need.

Foster Trust

So, what does it take to keep the subs you want to keep? In short, common courtesy followed by a few benefits. Construction is a relationship game, and nowhere is that more apparent than between contractors and subcontractors. Mutual trust is the basis for any relationship, and this case is no different. Fostering trust goes a long way toward convincing your subs to stick around.

Be upfront and clear about your expectations, and ask your subs to be the same with you.

When problems arise, talk directly to the sub, not to their workers, other subs, or the contract owner. Your subs need to know you’re behind them, and you value their contributions.

Money Talks

Show your subcontractors you appreciate them by paying well and paying on time. If you can streamline payments and payment processing, do it. Take on jobs where you can get the kind of returns as it will allow you to pay them well. Be careful of taking on too many low paying jobs. Your loyal subs will probably stick with you through a few; however, if it becomes the norm, they might look for greener pastures.

Have Their Interests at Heart

These days, subcontractors are on the front lines of the latest labor shortage. Those who have been around a while have seen all of this before; they are likely to have strategies for keeping their ranks staffed up. If they haven’t been through this before, you can help by practicing some understanding. Then, work with them on scheduling to help them make the most of the labor they do have.

Anything you can do to make your subs’ work easier will pay off in the long term. Working with them to find hidden surprises and involving them in scheduling discussions are two areas that pay big dividends in reducing their headaches, and yours. If you use a project management solution like Procore’s, you can invite your subs to use the same platform thus helping them streamline their submittals, RFIs, change orders, scheduling and more.

Most subs can’t stay busy working with just one GC. Help them by referring them for jobs you don’t want to take on and by supplying references.

These strategies might help you hold on to the subs you have. What about when you need to replace a sub, or you need more subs for a big job? Consider these tactics.

Connect With Other People

Other people often hold the answer to your subcontractor search. Tell people what trades you’re looking for, and ask whether they know anyone who might be available. While you’re at it, try to get a reading on referred subs’ reputations. Ask people at lumberyards and construction supply houses. Ask outside salespeople who visit your jobs. They are on job sites all around you, and they offer introductions as well as specific information about subcontractor performance.

Tell people what trades you’re looking for, and ask whether they know anyone who might be available.

Check in with glass companies, concrete companies, millwork producers, flooring companies and other firms that sell materials and supplies to the construction market. Try connecting with their outside salespeople, too.

Be Visible on Job Sites

As you drive around, visit projects you see underway. Introduce yourself, observe the work, and leave your business card with tradespeople. In these situations, you might meet other GCs, and by establishing relationships with them, open up opportunities to employ subs they know when available.

Check Your History

History is also a good source of subs. Review the subs you’ve had in the past and reconnect with them. Regardless of the reason you aren’t working together, times change, people change, and businesses change. Things could be different, and the two of you might find rekindling the relationship is mutually beneficial.

Use Networking

Use your networks like contractor associations, online contractor forums, organizations you belong to, and your acquaintances. Many semi-retired construction people have a lot of experience and skills. If you can offer them the flexibility they need, you can tap a growing cadre of skilled people. Military veterans who worked in construction and engineering roles in the service can be helpful, as well.

Try the Service Trades

Also, consider service plumbing, electrical and HVAC companies looking for short and long-term projects to supplement their service businesses. Just be ready for higher rates, and remind them regularly when they’re due to perform on your projects.

Become a Stepping Stone

If you need subcontractors with very small businesses, like one or two people, try to think of how the work you have for them would help them get future jobs. For example, a remodeler says he found a plumber who used to do mostly multi-family but decided he’d rather do the service work for single family. The remodeler hired him for the remodels, getting his name out for the service side work he wanted.

If you liked this article, here are a few eBooks, webinars, and case studies you may enjoy:

7 Strategies for Hiring and Keeping During the Labor Shortage

Help Wanted – How Technology is Fighting the Construction Labor Shortage

KBD Group Study


3 things to you need to know for Year End

3 mice

by Ruth Stockdale, LAI Director of PSG

Year end is just weeks away. There has been, and will be, a lot of information from Sage about year end processing and your software.

No matter what product line you use or what year it is, there are three basic things you need to find out:

  1. Know which version of software you are on.
  2. Know the version of software required for you to have compatible year-end tax updates.
  3. Know the date you have scheduled with your consultant to make any necessary upgrades.

The answers to all three questions will change from year to year, but the questions will always be the same. Plug them into a reminder on your calendar for October or November each year.

For this year-end, look for detailed information in this newsletter for both Sage 100 Contractor and Sage 300 CRE and Sage City’s Year End site.  And be sure to contact us if you need assistance.

Let us know if we can help! It’s No Big Deal.

Ledgerwood support

 


Your Official Guide to Preaccounting

Reprinted with permission from Sage Intacct | by Dave Cardoza, Expensify | Posted October 15, 2019  | Original post here.preaccounting

Preaccounting is the mundane, tedious work that nobody wants to do, but everybody needs to do before the truly valuable accounting work can begin. But what is it exactly? Here’s a more formal definition:

Preaccounting [pri–uh-koun-ting] (noun)

The system through which financial data is gathered, coded, aggregated, and normalized so as to enable accounting to occur; accounting processes executed by non-accountants, including expense management, time tracking, etc.

Why should preaccounting matter to you?

If you’re currently stuck sorting through piles of client receipts, confirming billable hours and mileage, or carrying out similar manual tasks that could be automated – you’re losing precious hours that you won’t get back. Your progress toward taking more of a “trusted advisor” role slows because of many bottlenecks that feel out of your control.

How can you make your preaccounting process more efficient?

An efficient preaccounting process ensures happy clients and smooth sailing throughout the year, from month-end close to tax season. We’ve compiled some high-level tips, tricks, and pointers in the table below to guide you on your journey toward a more efficient preaccounting process.

Preaccounting Inefficiencies

Manual processes are still the norm

Manual data entry, crumpled receipts, and lost paperwork are the norm and not the exception at your firm or with your clients.

Lack of urgency

Without consistent check-ins and deadlines to follow – driven by the accountant – many clients fall into the dreadful habit of submitting receipts and other expenses at the last minute, every month.

Create a timeline of expectations with your client that emphasizes a more real-time workflow, where both sides collect and report data as it’s received. Look for software that prioritizes automation and allows clients to submit receipts and expenses on-the-go. If a solution offers built-in client reminders, all the better!

Lack of accountability

Since preaccounting is not technically anyone’s responsibility, it’s assumed that both the accountant and client will do their part. In the end, however, it’s the accountant’s job to make sure things get done on time.

Outline a clear set of responsibilities for both parties – accountant and client – so that there’s no confusion about who plays what role in the preaccounting process. It also helps to show clients the bigger picture of how bottlenecks in areas like accountability affect success downstream.

Lack of incentive

This is especially prevalent in old-school expense reporting workflows, where the client already knows reimbursement could be weeks – maybe even months – away. The process of tracking down receipts and organizing paperwork isn’t alluring by nature, so accountants are left in an awkward limbo.

Best ways to resolve them

Identify bottlenecks in your current workflow and then picture what an ideal, automated preaccounting process would look like. Survey your team to see where they’re spending a majority of their time on manual tasks, then seek out a solution that will help them focus on more important work.

Create a timeline of expectations with your client that emphasizes a more real-time workflow, where both sides collect and report data as it’s received. Look for software that prioritizes automation and allows clients to submit receipts and expenses on-the-go. If a solution offers built-in client reminders, all the better!

Outline a clear set of responsibilities for both parties – accountant and client – so that there’s no confusion about who plays what role in the preaccounting process. It also helps to show clients the bigger picture of how bottlenecks in areas like accountability affect success downstream.

Convey to the clients why finishing their preaccounting tasks early or on time will be beneficial to their job and happiness. Incentivize quick submissions with timely review and reimbursement. Alternatively, consider a corporate card so clients won’t need to pay out of pocket or wait for reimbursement at all.

P.S. Speaking of preaccounting efficiencies – did you hear that Expensify just released the Expensify Card? With the Expensify Card, Expensify becomes a one-stop shop for all of your expense management needs from swipe to settlement. Learn more and sign up today at card.expensify.com.

Mobility for Sage 100 CON and Sage 300 CRE

Get to know Core Cloud Systems! — Wednesday, November 14, 2019core cloud webinar

Core Cloud Systems (CCS) gives businesses complete control over dedicated information streams for a connected, more convenient data management experience.

With this single system you can:

  • Design business forms
  • Collect employee or contractor data
  • Create customized portals
  • Analyze financial data, and more!

Available modules

CCS, from Core Associates, lets you build and deploy custom form applications and more, all from a single platform. An easy to use wizard walks you through it, plus it has seven solutions pre-built to get you going, including:

  • CCS Daily is a solution for submitting and collecting daily production reports.
  • CCS Time is a time management solution for tracking hours worked.
  • CCS Credit Card is a credit card reconciliation solution for balancing paid and outstanding credit charges.
  • CCS PO is a purchase order management module for producing and tracking work order documentation.
  • CCS Inv-Control is an inventory control module that alerts users to excess or low-level stock thresholds.CCS Bid lets you track bid submittal progress from start to finish in a single, mobile module.
  • CCS Sub is a subcontractor portal that allows organizations to standardize how they collaborate with vendors using powerful, custom controls.

Register for Ledgerwood

 


Lunch Box Talks for Sage 100 CON and Sage 300 CON

Great attendance so far and free!

New and FREE! Get ready for Year End with these live events hosted by LAI Consultants
Cozy up to your computer, break out the PB + J sammy, and learn how the Consultants close the year in Sage 100 Construction. Classes will be held ONLINE, Thursdays at 11 AZ time.

*NOTE* – The “TICKETS” link sometimes does not work – a working url is in the body of the event

Missed any past events?

That’s OK. We recorded them for you and published them on the Ledgerwood Channel on You Tube. Watch (and follow, please) them here:

you tube icon


Nov
21
Thu
Sage 100 CON Lunch Box Talks @ Go To Training
Nov 21 @ 11:00 pm – Nov 22 @ 12:00 am

GL vs. Job Costs Reconciliation

Join an LAI consultant for a live, online FREE session.

 

Register here: https://attendee.gototraining.com/r/8535331046523833090

Dec
5
Thu
Sage 300 CRE Lunch Box Talks @ Go To Training
Dec 5 @ 11:00 am – 12:00 pm

W2 Prep for Sage 300 CRE

Bring your own lunch and join an LAI consultant for a live, online FREE session on preparing and processing W2s.

 

Register here: https://attendee.gototraining.com/r/9081224276655031297

Dec
10
Tue
Subcontractors: Connect your field and office teams with eSUB + Sage @ GoToTraining
Dec 10 @ 11:00 am – 12:00 pm

Want to see eSub in action? Join LAI and eSub for this online event!

Free webinar, October 24, 11:00 am, MST

In your construction company, many people across departments need to work together to ensure that projects run smoothly. How can you drive better collaboration to ensure everyone is more productive? Mobility!

Learn more about Sage 300 CRE + eSUB, the leading field data collection and project management platform purpose-built for trade contractors.

You will learn how to:

  • Capture jobsite activity from a mobile device to keep the office team up-to-date in real-time
  • Integrate operations and financial systems to reduce manual data entry and increase accuracy
  • Establish best practices to standardize operations and improve efficiency

Register for Ledgerwood

Dec
19
Thu
Sage 100 CON Lunch Box Talks @ Go To Training
Dec 19 @ 11:00 pm – Dec 20 @ 12:00 am

Year End Close Out Procedures

Join an LAI consultant for a live, online FREE session.

 

Register here: https://attendee.gototraining.com/r/5275628714865636866

 


 

accounting-tips

Commuting Deductions Set By Tax Court

Submitted by Bryan Eto, CPA BeachFleischmanvehicle-tax-cut

Although you usually can’t deduct typical “commuting” expenses from home, you may qualify for a special exception if you’re away working on temporary assignments. But the IRS and the U.S. Tax Court won’t allow borderline deductions, as evidenced by one case involving a construction worker.

We’ll explain what happened in the case, but first, here is some background information.

Basic Rules for Temporary Assignments

“A taxpayer’s costs of commuting between his or her residence and place of business are generally nondeductible personal expenses, regardless of the distances involved.”
— U.S. Tax Court

Generally, the cost of commuting between your home and a place of business is nondeductible, regardless of the distance traveled. But there are several tax law exceptions to this rule. For example, if your home is your principal place of business, commuting to another business location is deductible. Another exception is allowed for travel between your home and temporary work locations if you have one or more regular business locations away from your home.

For these purposes, a temporary assignment in a single location is one that is realistically expected to last (and in fact, does last) for one year or less. However, if the job is indefinite, the location of the assignment effectively becomes your new “tax home,” so you can’t deduct travel expenses to and from there. An assignment or job in a single location is considered indefinite if it is realistically expected to last for more than one year — whether or not it actually does last more than one year.

Similarly, you may deduct travel expenses between home and temporary work locations outside the metropolitan area where you normally live and work. But there is no strict definition of “metropolitan area” in the tax law for the courts to follow. Courts will consider the relevant facts and circumstances in each case in determining if the expenses of a particular taxpayer were incurred traveling to a worksite unusually distant from the area where the taxpayer normally lives and works.

Facts of the Case

Kristopher Saunders performed construction services as an employee of Valley Interior Systems, located in Cincinnati. But Saunders never reported to the Cincinnati office of Valley Interior Systems. Instead, he traveled to five temporary worksites. None of the jobs lasted longer than a few months.

The temporary worksites ranged in distance from 74 miles to 96 miles from Saunders’ home in Manchester, Ohio. Each day, Saunders drove directly from his residence to the current worksite and then straight back home at the end of the workday. For reasons that were not explained in the record, Valley Interior Systems didn’t reimburse Saunders for any of the costs of commuting between his residence and these five worksites.
On his federal income tax return for the year in question, Saunders claimed a $23,802 deduction for unreimbursed employee business, mainly attributable to auto expenses for commuting between home and the temporary worksites. The IRS disallowed practically all of it.

After examining the exceptions to the general rule concerning commuting, the Tax Court said that Saunders could not deduct the travel expenses. Reasons: The court noted he had no regular work location during the tax year in question. Also, Saunders testified that his “main area” was the “Cincinnati metropolitan area.” The evidence didn’t establish that any of the temporary worksites where he worked in 2007 should be considered to be outside of the Cincinnati metropolitan area in order to qualify under the tax law exception and he was not eligible for any other exceptions to the general rule. (Saunders, T.C. Memo 2012-200).

Saunders argued that he should be able to deduct his commuting expenses because he was permitted to claim them for a prior year. The Tax Court stated that he was mistaken in making this argument. “Each tax year stands on its own and must be separately considered,” it added. “The IRS is not bound in any given year to allow a deduction permitted for a prior year.”

Best Practices

The optimal approach for an employee is to have travel expenses to temporary worksites reimbursed by his or her employer. The reimbursements are tax-free to the employee. Otherwise, a taxpayer should try to qualify for commuting deductions under one of the exceptions outlined above. Remember that a temporary assignment is one that is expected to last for less than a year — regardless of the actual length of time.
Also, note that the courts won’t be inclined to be sympathetic if you claim deductions for commuting to temporary job sites that are nearby. The IRS and courts will likely disallow deductions if you’re commuting within the same general metropolitan area.

Finally, be aware that employee travel expenses must be claimed as miscellaneous expenses on your personal tax return. Only the portion of your miscellaneous expenses exceeding 2 percent of your adjusted gross income (AGI) is deductible. This 2-percent-of-AGI floor is difficult to meet and creates an additional incentive to seek employer reimbursements.

Beach Fleischman 2201 E. Camelback Rd. Phoenix, AZ 85016 | 602.265.7011 | http://beachfleischman.com | twitter: @BeachFleischman

 


Be thankful you are ready for Year End

by Pam Schulz, Sage Senior Certified Consultant

Plan and prepare now!

Everyone using payroll records in Sage MUST “Archive” the 2019 payroll files prior to creating any payroll records for the new year, 2020.

The actual ARCHIVE process must be done within a certain timeframe — after the last payroll for 2019, but before the first payroll records for the new year. (There is a separate “General Ledger” archive; however because the timing of that archive is flexible, it is not discussed here.)

During January, W-2, 1099 forms and other tax reports will be required.

What to do and when

  1. Order tax forms, or consider other options: Sage 100 Contractor uses W2 (and 1099) forms that are known as “4-up” (four to a page). If you order or buy the most common forms at an office supply store you will be getting the wrong forms. Here are some other options:
    1. Order forms from Sage
    2. Order from another source — make sure you get the correct forms
    3. Use aatrix “full service” to print and send your forms for you
    4. Print to plain paper — you will need to work around getting envelopes that fit or use labels
  2. Sign up for training.
    1. LAI Lunchbox Talks: December 19, Year End Close Out Procedures. https://ledgerwoodusa.com/upcoming-events-calendar/
    2. LAI Lunchbox Talks: REPLAYS AVAILABLE HERE
      1. Employee W2 Prep and Audit — https://www.youtube.com/watch?v=1qFeSR9qokQ
      2. 1099 Prep for Sage 100 CON — https://www.youtube.com/watch?v=SW-Tt0hMwJo
    3. TUG (The Users Group- membership required)
      1. TUG Year End Webinar Series — Sage 100 Contractor: Payroll Archiving, W2 Processing on December 11, 2019 https://www.tugweb.com/events/event_list.asp?DGPCrSrt=&DGPCrPg=2
      2. Watch the LAI newsletter next month for more!
  3. Prepare for 1099s
    1. Review report 4-1-1-61, Vendor 1099 report. Here you see how much was paid to each vendor, their 1099 type, and their ID number. CLEAN THIS UP NOW. Follow these basic rules:
      1. No one should have a type of “undetermined”- if a vendor does not get a 1099 use the type for “No 1099” rather than “undetermined.”
      2. Anyone with a 1099 type that requires a form MUST have an ID number.
    2. “Test run” your 1099 forms using aatrix at menu option 4-5, 1099 forms. If you have trouble loading aatrix, get this solved NOW. If aatrix shows “errors” in vendor IDs, or other data, fix it now.
    3. Order forms, or get set up/enrolled for aatrix services – don’t wait.
  4. Prepare for W2s
    1. Run a payroll audit at menu option 5-3-7, and address all audit errors.
    2. Test run the W2 forms at menu option 5-4-1. Aatrix will show errors such as duplicate Social Security numbers, missing addresses, etc., Fix your data now.
    3. Reconcile/Balance your 941 forms against the W3 totals. Create an excel worksheet to list the Wages, Tax, FICA wage, and Medicare Wage from each quarter’s form 941. (This should also be done for your states.) Run the payroll reports for Q4. You can do this “now/early” if you like (the idea is to spot errors, not to produce a final report). Compare the totals with the information on the W3 form (or grid totals in the screen) created in your test W2 run. Now is a good time to file any needed forms 941x.
    4. Order forms, or get setup/enrolled for aatrix services- don’t wait.
  5. Prepare for ACA
    1. You may need to file ACA reports (Affordable Care Act.) Check with your advisors about this requirement.
    2. Complete the employee information at menu option 5-2-1, Employees. There is a “tab” for the ACA information.
    3. Run the informational reports for review at menu option 5-4-3, ACA reports.
    4. Test run the reports that will be filed in aatrix at menu option 5-4-1; they are listed with the other Federal tax reports.
  6. Prepare for the BIG NIGHT

Between your last payroll check of 2019 and your first payroll record in 2020, you must “archive” your payroll files. You will also “update” the new year’s files with new tax rates, and perhaps perform some employee maintenance in vacation and sick accruals. All of these tasks will be covered in future discussions, but for NOW, get as much done as possible! More preparation = less stress!

Need help from a certified Sage 100 Contractor Consultant? Just click, and we’ll contact you in a jiffy! It’s ‘No Big Deal, right?


Year-End Preparation for Sage 300 Construction and Real Estate

by Kyle Zeigler, Sage Senior Certified ConsultantSage 300 CRE year end

The beginning of the holiday season is fast approaching! Being prepared for year-end activities in your Sage 300 CRE software can help make your holidays the happiest. Some items for your “to do” list might include:

December Tasks

1. Version upgrade

The only version supported at year-end will be 18.3 and this should be installed prior to 12/31/2019. Schedule with your consultant early!

2. Year-end update

Watch for an email from Sage during the last couple of weeks in December. Identify who receives those emails in your organization. Install only after upgrading to version 18.3.

3. Order 1099 and W2 forms if printing in-house

Be familiar with the correct forms to order — there are limitations (only 4-up for both, blank on the front; W2s must be pre-perforated). Or let Aatrix print and send your 1099 and W2 forms so you have more time for holiday shopping!

4. 1099 prep in Accounts Payable

Check the 1099 year in AP Settings to assess whether corrections will need to be made to 1099 totals for 2019 forms. Review and modify Vendor 1099 settings as needed.

January Tasks

1. Payroll

Plan when to prepare and post your last payroll for 2019, including any bonus or supplemental checks that will be dated in 2019 and will use 2019 tax tables, when to download and update taxes, and when to begin processing the first payroll of 2020 with the new tax tables. Also, plan when to prepare and finalize W2s.

2. Accounts Payable

Plan when to prepare and finalize 1099s.

3. All other modules

Plan the timing for reconciling to GL, printing year-end reports, and closing the year for modules that have a Close Month and Close Year task. GL is typically closed last.

Where to get help:

As always, please let us know if we can assist you in any way.

Need help from a certified Sage 300 CRE Consultant? Just click, and we’ll contact you in a jiff! It’s no big deal, right?

 


Sage-estimating-tips-and-tricks

Copy and Paste from Excel to the Database Editor

by Renee Mullen, Marketing Manager, Sage Construction and Real Estate

New in version 19.11 of Sage Estimating is the ability to use direct copy/paste from the Sage Estimating Database Editor to and from Microsoft Excel and other spreadsheet software. If you are new to using Sage Estimating or you have been using item lists and estimates created or managed in Microsoft Excel or some other spreadsheet software, it is now possible to easily transfer data from those spreadsheets directly to a Sage Estimating database using the built-in Windows copy and paste functions rather than importing or exporting entire databases.

From Sage Estimating Database Editor to Excel:

  1. Select the rows/columns/cells you would like to copy. If you copy an entire row, there is no need to also copy the column header row as the headers will automatically be included.
  2. Columns that are hidden on the current database layout will be hidden when the data is pasted into Excel. Columns are also copied/pasted in the order in which they appear in the Database Editor, so it is important to be sure that the layout in Excel matches the layout in Database Editor before using copy/paste.

From Excel to Sage Estimating Database Editor:

  1. Be aware that if the data copied from Excel contains columns not already in the current layout, Estimating will shift the current layout to accommodate the data from Excel.
  2. If the data being pasted contains a setting for precision rounding but the current layout does not include a column for that rounding direction, Estimating assumes the intended rounding direction to be “closest.”
  3. If the data being pasted contains a column for Material Class Description but Material Class description is not an enabled column in the current layout that column is read as read only and therefore is not included in the data to be pasted.

For more information on this topic visit Knowledge Base Article 101393. You can find this information and more in the Knowledgebase.

Join the conversation at Sage City available 24/7, the online community is your gateway to many Sage resources.

Find more of TUG’s Tips and Tricks HERE.