Dynamics GP Check Printing

This is a basic process in Dynamics GP and there are a couple of ways to manage check processing.

you can create a batch of invoices to pay based on various selection criteria that select invoice from your entire payables list. But you can also go vendor by vendor, and select the individual invoices you want to pay.

You can easily make partial payments on invoices if you want.

Any payment discounts that are assigned to an invoice will automatically be calculated and deducted from the payment.

The process for creating EFT files uses the same basic process.

This is a video that shows one way to put a check batch together:

Printing Payables Aging Reports in Dynamics GP

There are various options you can use to get payables information out of Dynamics GP.

You can use the standard reports, SmartLists, Excel, or another reporting tool that can access the SQL database.

This video shows one of the more conventional reports:

Adding Vendors in Dynamics GP

Dynamics GP allows you to control the addition of vendors to your vendor master file. You can set up vendors to simplify accounting and payables purchasing transactions.

You can specify settings for 1099 reporting that greatly simplify the accounting for and reporting of payments made to 1099 vendors.

You can specify Vendor Classes to organize vendors for easier reporting and data entry.

Vendors are automatically added to the rich SmartList reporting tool that make getting to data quick and easy.

Here’s a quick video that shows you how to do this:

Is moving to a new accounting System possible by January 1st

Calendar-Planning-photo

 

December 1st is quickly approaching and the angst of knowing that a new accounting system is needed looms before you.  While the business of doing business has been all consuming during the last 11 months, the notion of sending one more year on an inadequate accounting system seems unfathomable. If you plan on taking any time off for the holidays, is moving to a new system by January 1st even possible?  Well, relax. You actually have more than 28 days because some of your “Go Live” tasks are actually done after you cut-over to your new accounting system.  Here is a realistic timeline on how you can accomplish this with myGPCloud.

Overview:

Week 1 – define chart of accounts and financial reporting needs – predefined in myGPcloud

Week 2 – extract from your existing system/clean/modify – vendors, customers, and inventory master lists

Week 3 – import vendors, customers, inventory items

Week 4 – bring in open balances such as month end trial balance numbers, open accounts payable, accounts receivable, inventory items costs and balances, purchase orders and sales orders.

End of Week 4 – GO LIVE

Post Go Live:

Week 1 – Develop your financial reports – predefined in myGPcloud

Week 2 – Open Bank transactions – enter outstanding checks and deposits in transit

Looking at the details

Week 1 – First let’s look at some of the time consuming tasks that have already been taken care of for you with myGPcloud.  The key to every good ERP/accounting system is the chart of accounts.  After all, it is the basis of all your financial reporting.  If you get this wrong you will be cursing yourself for years to come. It is no wonder why CFO’s, controller and business owners spend countless hours trying to come up with a COA that allows for growth, best practices in reporting and significant enough visibility to manager and bankers without going overboard on the number of accounts. And those are just the posting accounts. You also have to think about departments, location or product segmentation reporting.  Whether you are a simple start up business or a sophisticated distribution or manufacturing company or a complex professional services company, myGPcloud has a chart of accounts thought out for you already.  We have predefined four very unique charts to handle general business, supply chain, manufacturing and professional services businesses.

Week 2 – If you are moving from another accounting system like Quickbooks, Peachtree or many of the Sage products, extracting your master data files can be done quickly and easily into Excel.  From there you will want to clean out any old vendors, customers and inventory items you no longer use and you might also want to re think their ID’s.  myGPcloud allows for 16 characters in each ID field and you can use alpha-numeric as well, if you like.

Week 3 – Now that your data is nicely organized and current, you can use our simple integration manager tool, which comes standard with the product to import into Dynamics GP these items.  If you need help or have a lot of items, we have a fixed price list for help on importing these items.

Week 4 – This week usually falls during the last week of December between the holidays. So depending upon your business, this can either be a quiet week or a busy one; so make sure you plan accordingly.  Many customers try  to print checks out of their old system and hold on to them while they transition over to their new system to avoid having to enter too much open AP. Open AP can be easily manually entered as well as open purchase orders if you have less than 20 – 40 of each.  More than that and we recommend doing an import, again using Integration Manager in Dynamics GP.  Open AR however is usually something out of your control, so you will have to enter, or import in these transactions so that your AP and AR agings match your old system.  Open Sales Orders are also recommended to be manually entered if possible, as many of these will affect inventory balances as well, so make sure you enter your inventory balances first.  Remember once you move these over, no more transactions should be entered into your old system.

GO LIVE – Well you are about to start entering into your new myGPcloud system.  Make sure you have check stock on hand that will work with your new system – myGPcloud uses most existing check stocks but some manual changes may need to be made.  This might also be a good time to take a copy of your database and move it into a test company.  Reach out to the support team at myGPcloud and they will do this for you.  Then go into your test company and run some transactions; purchase orders, sales orders, accounts payable invoice entry, journal entries, etc., and print out all the items to make sure that everything looks the way you want it to.  Make sure you view our videos and blogs on the 10 steps to going live with myGPcloud.  These are helpful videos and blog posts to get you through the common questions.  Or reach out to the support team as all new customers have 5 technical support calls at no charge.

Post Go Live – Week 1 – Well now that you have gone live and are entering transactions into your new system, getting financials or reporting is your next important task. If you are using the predefined charts that came with the system initially, you are ready to print financials.   If you added accounts, you will just need to go into the report writer and add them there.  With myGPcloud we have pre-written the following reports for so all you need to do is print them as needed.

  • Summary Balance Sheet
  • Detailed Balance Sheet
  • Summary Income Statement
  • Detailed Income Statement
  • Detailed 12 month Income Statement
  • Trial balance

Post Go Live Week 2 –  By now you have probably received your bank statement or you can go on line to print one out.  But in order to use the Bank Reconciliation module you will need to enter in (from your last bank reconciliation) your deposits in transit and un-cleared checks.

Hopefully this quick recap will give you the confidence that you can move to a new accounting system with just 30 days left to January 1st. It will take some dedication on your part, but well worth the effort when you realize all the great features that you will get with your new myGPcloud system.

Purchase to Pay Cycle

Purchase to Cash

The basic purchase to pay cycle can be represented as this image below:

Managing the purchase to pay cycle effectively will help you improve your working capital position. These are some of the things you can do to improve your cash cycle:

  • Commit to purchases and delivery dates that match your real requirements. Don’t schedule deliveries too early.
  • Record inventory receipts as soon as they arrive so your inventory records are always up to date, and you’re gathering accurate delivery statistics for your vendors.
  • Record vendors’ invoices accurately for amounts and payment terms
  • Ensure that you have sufficient controls to avoid duplicate payments and unauthorized payments
  • Monitor your outstanding payables to make sure you’re taking advantage of payment discounts, not paying too early, and paying accurately to maintain good relationships with your vendors
  • Control check stock and other payment delivery methods to ensure all payments are authorized
  • Make regular and timely payments to match your business rules and facilitate the quick review and processing of payments

A well integrated ERP cloud system can help you meet these guidelines by coordinating operations, inventory, purchasing, financial control, and financial reporting functions. These are some of the things that will improve your cash cycle and working capital position.

This set of videos shows how you can use Dynamics GP to improve your cash cycle: http://youtu.be/lZiItcJkGYI

 

 

Dynamics GP Videos in Streamlined Format

video-clip

 

Take a look at these two new video formats for Dynamics GP.

There’s one for the purchase-to-pay cycle and one for the order-to-cash cycle. These two videos allow you to pick which step in the cycles you’re most interested in. In many cases there are links to other more in depth videos about the subject.

This format has a more interactive feel to it. Let us know if you like it.

Purchase-to-Pay Cycle

Order-to-Cash Cycle

General Ledger Accounting

1099 Processing in Dynamics GP

1099 1

Setting up, processing and reporting for 1099 payments is easy in Dynamics GP.

There are basically three steps:

  • Set up the vendor and identify as a 1099 vendor
  • Process payables transactions to record the 1099 amounts, and issue checks
  • Run the routine 1099 reports and adjust 1099 amounts if needed

Vendors can easily be identified as 1099 vendors in the Vendor Maintenance Options screen:

When making payments to 1099 vendors, make sure that the correct 1099 amount is recorder in the 1099 Amount field. The screen will default with the entire purchases amount. This amount can be modified if the entire amount of the invoice is not a 1099 amount. This can happen if vendors include supplies and services on the same invoice.

Here is a video that shows this in action: http://youtu.be/HOGi_PE5WvQ

Vendors, Payables Invoices, and Checks in Dynamics GP

There are two main functions that almost everyone wants from an ERP system: decent financial reporting and an easy to use way to control and process accounts payable.

Control of accounts payable includes these concerns:

  • Security to system access and functionality
  • Supervisory control over transaction processing
  • Data entry edit and validation controls
  • Cash requirements reporting
  • Duplicate invoice detection
  • Easy and accurate posting to the general ledger

Dynamics GP provides all these controls along with a smooth workflow to allow for efficient and effective payables processing.

This video shows the whole cycle of adding a new vendor, entering a new payables invoice, and creating, printing and posting a check batch: http://youtu.be/SaQVW98WXNg

EFT for Payables with Dynamics GP

Sending payments by electronic funds transfer (EFT) is becoming increasingly popular. It’s popular for several reasons:

  • Reduces opportunity for fraud
  • Reduces expense for check stock and printing/mailing supplies
  • Reduces the amount of time related to processing payments
  • Payees generally like it better

There are three steps to take if you want to implement EFT payments in your organization:

  • You need to arrange with your bank to submit payment information via EFT
  • You need to get the pertinent bank account information from all your vendors who want to be paid via EFT
  • You need software to get the payment information from your ERP system and format it in manner consistent with you bank’s requirements

Dynamics GP offers an efficient and effective way to generate an EFT file within the normal check writing process.

This video shows the EFT for Payables functionality in Dynamics GP. It shows basic setup and use, including sending the remittance document via e-mail: http://youtu.be/300VySKxhoo

Dynamics GP Accounts Payable Setup

Payables Management Setup

Setting up the Accounts Payable module in Dynamics GP is straight forward. There are a few areas you will want to make sure meet your business requirements:

  1. You can set up aging periods as you wish, using up to 7 buckets. You can always change these in the future if you want.
  2. Make sure that the control over duplicate invoice entry is set up the way your want.
  3. It’s also a good point at which to set up Vendor Classes. These help with reporting/inquiry, and new vendor entry.

This video shows the minimum accounts payable setup for a new GP company: http://youtu.be/tkZ6lUgTJuU