Posts

Sage 100 – Credit Card Processing For Accounts Receivable And Sales Orders

Question:

Mike, We own Sage 100 Accounts Receivable and Sales Order, we would like to use Credit Card Processing, is that possible?

Answer:

Yes Sage 100 Accounts Receivable and Sales Order Modules are fully integrated with several payment processors and transactions can be integrated through Accounts Receivable Cash Receipt Entry and Sales Order Entry without having to go outside the Sage 100 Accounting System.

NOTE: We advise that you consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100  system.

Optimize Cash Flow and Get Paid Faster

Sage 100 integrates with Paya, formerly Sage Payment Solutions, to process credit and debit card receivables quickly and conveniently?  Look at all the benefits of adding payments to your Sage ERP!

  • Accept all major credit and debit cards as well as PIN debit and signature debit transactions.
  • Securely store bank and credit card information in the Paya vault—not your software (simplifies PCI compliance).
  • Access the data you want whenever you need it.
  • Reduce the risk of theft, credit card fraud, and legal action with strict adherence to the highest industry standards.

About Paya
Paya was the first – and remains the best – Sage 100 direct integration, with easy onboarding and a powerful, user-friendly payments interface.
Paya offers industry leading payments solutions that can be tailored to meet the needs of any business. A provider of exceptional business solutions and customer experiences, Paya delivers future-proof value and flexibility for growth.
Let Paya handle the movement of transaction data automatically. Consolidate, control, and reconcile all internal and external payment sources in real time. For more information, visit https://paya.com/ or follow us on Twitter: @PayaHQ, LinkedIn: Paya.com and Facebook: PayaHQ.

Sage 100 – How to Reverse a Check and Invoice in Accounts Payable

Question: Mike, we own Sage 100 (formerly MAS90) and we would like to know how to reverse a check and invoice in Accounts Payable.

Answer: Sage 100: How to reverse a check and invoice in Accounts Payable.

NOTE: We advise that you consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100  system.

Steps are show below:

  1. First Modules>Accounts Payable>Main>Manual Check Entry, and type in the check number you want to reverse. The system will ask you “Is this a Check Reversal”, click Yes.

2. The system will them ask “Do you what to recall invoices paid by this check”, click Yes.

3. You will then see a negative check on the register, Accept and Post the Manual Check Register.

4. So now you want to reverse the invoice with an Invoice Reversal, go to Modules>Accounts Payable>Invoice                 Data Entry.

5. Put in the Vendor N0. and Invoice No., and you will see the Invoice Adjustment popup, click Adjust.

6. Next put in a negative amount in the Adjustment Amount and Post the Invoice Register, this will reverse the                 Invoice.

 

Sage 100, How to add Vacation and Sick Accruals to Payroll Check on Sage 100 2018 and higher

Question: Mike, we own Sage 100 (formerly MAS90) we recenty upgraded to version 2018 and we previously had version 2015 in the old non Crystal version of check form, all the Vacation, Sick and PTO fields were lost, how can we get them back onto the new Check form.

Answer: This is explained below:

NOTE: We advise that you consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100  system. If you don’t currently work with a Sage 100 consultant, contact us, call 760-618-1395 or email us at info@caserv.com and we are available to help.

  1. The Payroll Module Database in version 2018 has been changed from previous versions, the Vacation Sick and PTO fields were changed and they are now named TimeOff1, TimeOff2, TimeOff3. They are named HoursAccrued, UsedHours, AnnualLimitHours, AvailableHours for each of the 3 type of Accrual. You can see a picture of the Crystal Reports Field Explorer  below that will show each of the fields.

 

2. In addition there is a new version of Crystal Report that is included with Sage 100 version 2018, Crystal 2016 and it needs to be installed so you can edit the new forms, the Payroll forms were completely rebuilt by Sage, as well as Sage Support does not support Modifications to the out of the box forms, so these instruction will help you modify the form and add the Accrual fields that to the Crystal Report. You can see a picture of the Plain from which you can start with. Click the form button from the Print Checks screen Modules>Payroll>Main>Print Checks and the Crystal Report will open.

3. Next what you need to do is drag the bottom line down from the Group Footer #2 to allow enough space to the insert the Accrual Fields, this is located just below the Net Earnings, the out of  the box form from Sage does not include the accrual fields so this is a customization. You will also want to reposition all the existing fields to the bottom, and then you can open the Crystal  field explorer and drag and drop the acrual fields into position as well as you can add text titles. You will need to play with this and it is mostly trial and error to get it printing in the right place. In addition you will need to reduce the stub lines on the check printing. You can also suppress the fields in Crystal and move fields that are out of position. This blog is just to give you the general idea of how to modify this form and not teach you all the details of Crystal Reports design.

 

 

 

 

How to run Sage 100 Accounts Receivable Trial Balance and Aged Invoice Reports

Question: Mike, we own Sage 100 (formerly MAS90) and we would like to know how to run the Accounts Receivable Trial Balance and Aged Invoice Report.

Answer: The Sage 100 Accounts Receivable Trial Balance and Aged Invoice Reports are explained below:

Accounts Receivable Trial Balance Report:

This report is used to Balance against the Balance Sheet report. It is a detail by customer of all Invoices, Payments and Deposits. The report should be used to be show a customer what their balance owed to your company is. The report can print for Invoices Open, Paid or All.

The report can be accessed from Modules>Accounts Receivable>Accounts Receivable Trial Balance, you can set the parameters and then print or preview the report.

Accounts Receivable Aged Invoice Report:

This report is used to print balances owed by customer on invoices, it can be printed with each column being Current, 30 days, 60 days, 90 days and 120 days past due. It is really a report to determine collection and which customer to called for payment.

The report can be accessed from Modules>Accounts Receivable>Accounts Receivable Aged Invoice Report, you can set the parameters and then print or preview the report.

SALES TAX AFTER THE SUPREME COURT WAYFAIR CASE

I want to thank Joseph F Bigane, III, CPA, MST for the following article on the resent supreme court rules on sales taxes.   Joe is one of the most knowledgeable person on this topic and he wrote this article for particularly for small businesses.

SALES TAX AFTER THE SUPREME COURT WAYFAIR CASE

On June 21, 2018 the world of collecting sales tax in jurisdictions all over the United States changed forever.  The US Supreme Court held that it was no longer required that a seller must have a physical presence in a jurisdiction in order for that state (or subdivision thereof) to impose an obligation on sellers to collect the jurisdiction’s sales tax.  The dust has not yet settled and many jurisdictions are still determining how and when they will impose this duty.  Further, different states have different taxes, which for this article will all be referred to as “sales tax.”  Finally, the rules of South Dakota, the state in the Wayfair case, established a floor of $100,000 or more than 199 transactions in the prior year as the minimum activity in the state in order for the duty to collect to be imposed.  Other states may have different minimums but it is anticipated that they will not be smaller.

Having to collect a State’s sales tax is referred to as having “nexus.”  This is not a new term.  Before the Wayfair decision, nexus was achieved by having some form of physical presence in the State.  Wayfair did not change that; it merely expanded it to include the concept of economic nexus – doing enough business in the state over the internet or by other, non-physical means to exceed a determined floor.  If the business had physical presence nexus before this decision then it has been exposed to the obligation to collect sales tax for a time period predating Wayfair.  Such a situation should be discussed with a professional that can help you “get squared away.”

Remote sellers who now have nexus in states outside their home states are going to have to consider the following issues:

  1. determine how much sales dollars was earned in each state in your last fiscal year and

your current fiscal year

  • sales are made to the location to which physical goods are shipped, not

to where they are billed

  • sales of services have special rules, but generally will be sourced to where

they are received or, if point of receipt unknown, where they are billed

  • revenue subject to sales tax will vary by state. It may or may not include:
  1. freight and shipping
  2. installation
  • training
  1. warranties
  2. determine if each state taxes your particular goods and/or services are the

goods/services that you sell exempt by state law

  • are the goods/services that you sell exempt to some or all of your buyers
  • if your buyers are exempt, you will need to obtain from them the appropriate

state exemption certificate

  1. do you sell by drop shipment
  • these sales will now be counted to determine if you exceed a state’s

floor and either tax or an exemption certificate will need to be collected

 

Unfortunately, the states do not at this time have a common set of laws stating what is and what is not taxable or exempt.  So, sales into one state may be taxed while sales into a different state may not.  Some states tax most services (SD, NM) while other states have a list of “enumerated services” which they tax.  Here, too, there may be wide differences in the definition of what a service does or does not entail.  If you sell or license software you will need to determine if the state considers it canned or custom or both.

 

While there is no fifty state determination at this point, nor is there any serious indication that the federal Congress will intervene to provide a national solution, there are many states which are setting up their rules to be applicable as of October 1, 2018 or January 1, 2019.  So, you do not have the luxury of putting this issue off.  Collecting sales tax is an administrative burden but the money is collected from your customer and does not come out of your bottom line.  If you fail to properly collect and remit taxes, and the state(s) ultimately find and audit you, then the money (tax, penalties and interest) will come out of your bottom line.

 

So now is the time to talk to your professionals and determine in what states you will have to register as a tax collector and how you will determine the amount of tax you will need to collect for each transaction.  While a certain number of states are members of the Streamlined Sales Tax Agreement and can provide a simplified method for registering and filing, it may still be necessary for you to invest in sales tax software to determine the correct amount to charge for each transaction.

 

Sage 100 How to Setup a Recurring Journal Entry

Question: Mike, we own Sage 100 (formerly MAS90) and we would like to know how to setup a Recurring Journal Entry.

Answer: The Sage 100 Recurring Journal Entry can be setup as explained below:

NOTE: We advise that you consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100  system. If you don’t currently work with a Sage 100 consultant, contact us, call 760-618-1395 or email us at info@caserv.com and we are available to help.

Steps are show below:

  • Essentially a Sage 100 Recurring Journal Entry is a monthly, quarterly, or some time frame that repeats for the same amount and the same General Ledger Account numbers. The Recurring Journal saves time, so you do not have to key in every month or period the same Journal Entry.
  • First go to Modules>General Ledger> Main>Recurring Journal Entry on the header select the Source Journal, Reference (Name of what you want to call the Journal), Cycle (Period that you would want to run such as MO for month or YR for year), Start and Stop Dates, and any Journal Comments that you want.

  • Go to the Lines Tab, set the Accounts, Debit and Credit amount that you want to use and any other comments for the lines and then Accept.
    • The steps above create essentially a template for the Journal that can be used over and over.
    • The next step is to run and post the journals, you can run one at a time or if you have many journals you run them all at once. Go to Modules>General Ledger> Main> Recurring Journal, select the correct General Ledger date that you want to run the Journals for, Print, and select the Source Journal, Cycle and Reference you want to use, in the example we just used Reference equal to DEPR, and then Proceed, this will create the Journal.

    • Then say Yes to Update the Recurring Journal.

    • You can then check and make sure the Journal correctly posted by reviewing Account Inquiry for one of the Journal Accounts as shown below.

New Tax Law Changes for 2018

By now we are all aware that there are new tax tables coming due to tax reform. While most everyone will see a difference in their paycheck by February 15, there are still some details that aren’t quite ready. As the tax law is written, there will be no personal exemptions for 2018. So, what are we supposed to do with those W-4 forms that we have from our employees?

The IRS recently released a notice with additional information regarding those W-4 forms. The notice extends the effective period of the current Forms W-4 until February 28, 2018 and does the following:

• Temporarily suspends the requirement that employees must furnish their employers new Forms W-4 within 10
of changes in status that reduce the withholding allowances they are entitled to claim;
• Extends the use of the 2017 W-4 Form until the 2018 W-4 Form is available;
• Provides that the withholding rate on supplemental wage payments is 22 percent for 2018 through 2025; and
• Provides that, for 2018, withholding on periodic payments when no withholding certificate is in effect is
based on treating the payee as a married individual claiming three withholding allowances.

Basically, it is going to take the IRS quite some time to redesign the W-4 so it reflects the changes in the new tax law, so to minimize the burden on employees and employers, the IRS and the Treasury Department designed the 2018 withholding tables to work with the Forms W-4 that employees have already furnished their employers. Once the newly designed 2018 Form W-4 is released employees will have 30 days to submit the new forms to their employers.

Bob Scott’s VAR Stars 2017 Announced

Bob Scott’s VAR Stars 2017 Announced

WAC Solution Partners has again been selected as a member of the Bob Scott’s VAR Stars for 2017, a group of 100 organizations honored for their accomplishments in the field of midmarket financial software. WAC Solution Partners have won this award every year since its inception in 2009.

Members of the VAR Stars were selected based on factors such growth, industry leadership and recognition, and innovation. Selection is not based on revenue and those firms chosen represent a wide range of size and many different software publishers of accounting software.

“Each year, 100 VAR Stars are picked from the best organizations that market financial software. It is always an honor to recognize those who contribute to the development of our business,” Bob Scott said.

About Bob Scott
Bob Scott has been informing and entertaining the mid-market financial software community via his email newsletters for 17 years. He has published this information via the “Bob Scott’s Insights” newsletter and website since 2009. He has covered this market for more than 25 years through print and electronic publications, first as technology editor of Accounting Today and then as the Editor of Accounting Technology from 1997 through 2009. He has covered the traditional tax and accounting profession during the same time and has continued to address that market as executive editor of the Progressive Accountant since 2009.

About PMG360, Inc.
Bob Scott’s Insights and the Progressive Accountant are published by PMG360. PMG370 (www.pmg360.com) is a leading online media company that provides business-to-business (B2B) marketers and media planners unparalleled access to a highly qualified and engaged audience through their portfolio of lead generation programs, industry-specific Web sites, email newsletters, Web seminars, live events, podcasts, content/reviews, custom publishing and direct marketing databases focusing on the nonprofit, healthcare and accounting professionals.

Sage 100 – How to Use Customer and Crystal Reports to Add a Custom Field and Run Reports – WAC Solution Partners – Palm Desert

Question: Mike, we own Sage 100 (formerly MAS90) and we would like to know how to add a new field to the Accounts Receivable Cash Receipts Entry screen. Is it possible to add a field to enter the number of customers that come our office daily?  We’d like to collect this data and build a report to show this information with different date ranges.

Answer: The Sage 100 Custom Office Module allows you to add a user-defined field to any screen in Sage 100 and report on it from the database. You simply add the new field to the Custom Office and create a simple Crystal Report. You will also need to properly link the UDF to History.

NOTE: We advise that you consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100 ERP system. If you don’t currently work with a Sage 100 consultant, contact us, call 760-618-1395 or email us at info@caserv.com and we are available to help.

Abila MIP Fund Accounting™ Consultant Success Story with CVEP

October 26, 2017/in Abila MIP Fund Accounting™, Non Profit /by Mike Renner

Coachella Valley Economic Partnership (CVEP) is a nonprofit economic vitality organization devoted to attracting, retaining and expanding business and developing a high-skilled workforce to enhance the economy and quality of life in the region.

Albia consultant nonprofit MIP.pngWAC Solution Partners Greater Los Angeles – Helping Businesses to Grow Effectively

As providers of accounting software, implementation and support, we offer a wide range of solutions designed to fit businesses and non-profits of all sizes. Our combination of products and services allow you to better manage your accounting and to make insightful decisions about your company’s future.

EXPERTISE WITH LOCAL ROOTS AND NATIONAL REACH

This is a success story that embraced persistence, partnership and always working with and looking out for our customers best interest.

We are very involved with the Coachella Valley business community. In 2014, a local CPA named Kelli Cox, was working with CVEP on their financial statements. CVEP had laid off their Controller. Kelli didn’t have time to do many of the accounting tasks they were requiring. She knew we were Abila MIP Fund Accounting™ Certified Consultants and brought us in to meet with Lesa Bodnar, Chief of Staff of CVEP.

Kelli recommended us to take over many of the accounting tasks due to our knowledge and expertise. CVEP also wanted additional training on Abila MIP Fund Accounting™ software for their staff. Mike Renner trained the staff on General Ledger, Accounts Payable and Accounts Receivable. Laurie Renner went onsite weekly to work on the Abila MIP Fund Accounting™  software, to make accounting entries and at the end of the month reconciled their bank statements. She also worked with Kelli to make sure the financial statements and board reports were ready for the board meetings. Laurie has been working with this client ever since. It’s an ongoing success story for 3 years now.

Some of the comments from the Chief of Staff – Lesa Bodnar are: