CAL Business Solutions Team
CAL Business Solutions
 
 

General Ledger Tips

Eliminate Manual Entry in Dynamics GP Tip #7 – Stop Rekeying Data

As a Dynamics GP consultant, when I see Dynamics users wasting time rekeying data from a spreadsheet, or another system, into Dynamics GP I cry a little inside. Not only is data entry mind numbingly boring, it is also very prone to error. (Probably because the typist is so bored). This interesting blog post estimates […]

continue reading... |

Eliminate Manual Entry in Dynamics GP Tip #6 – Automatically Create and Email PDF Documents

One of our Dynamics GP users said, “For years I did the laborious task of creating PDFs from invoices every month, one by one. Until one day, CAL showed me how to set up the auto-creation of PDFs and recurring billing. It changed my life!” Once your PDF is created you can then use the […]

continue reading... |

Eliminate Manual Entry in Dynamics GP Tip #5 – Use Scan and Save to Stop Filing Paper

It used to be that office walls were lined with file cabinets to hold all the paper documents. Sadly, some of them still are. But it is easier than ever to “go paperless”. The Manual Way to Do This Just out of habit, many of us still like to keep paper documents. We sort them, […]

continue reading... |

Eliminate Manual Entry in Dynamics GP Tip #4 – Stop Tracking Fixed Assets In Spreadsheets

How do you track your fixed assets? The Manual Way to Do This We find that many companies still track their fixed assets on an Excel spreadsheet. Or worse, they pay an outside consultant, such as an accounting firm, to track the assets for them. But this can be done right in Dynamics GP, in […]

continue reading... |

Eliminate Manual Entry in Dynamics GP Tip #3 – Stop Depositing Checks with Lock Box Processing

Getting more checks in the mail is a good thing for a company. You are making more money. But what about the extra time involved? Lock Box Processing in Dynamics GP can help. The Manual Way to Do This When you receive a check, you open the envelope, record the payment, and take the check […]

continue reading... |

Eliminate Manual Entry in Dynamics GP Tip #2 – Send EFT Payments with Automatic Emails

How do you send online payments? There is an easy, and inexpensive way to do this directly from Dynamics GP without a lot of manual processes. The Manual Way to Do This Let’s say you are booking an event venue and the deposit is $10,000. You could manually print a check (or heaven forbid, write […]

continue reading... |

Eliminate Manual Entry in Dynamics GP Tip #1 – Using SafePay to Submit Files to Your Bank

Check fraud is a big issue, and banks have put security measures in place. But often these security measures require extra work on your part. Most banks, if you are cutting over a certain threshold of checks require that you submit a file to the bank that includes the check number, the check date, the […]

continue reading... |

Microsoft Dynamics GP with Excel Tip: How to Copy/Paste GL Transactions from Excel to Microsoft Dynamics GP in 4 Easy Steps

Using Microsoft Dynamics GP and Excel are a powerful combination for any finance team. Many of our clients are asking about the steps to copy and paste General Ledger transactions from Excel into Dynamics GP. Here is the process in four simple steps.

continue reading... |

Microsoft Dynamics GP Tip: How to Fix Assets and Re-Depreciate After You Have Posted to The GL

One of our clients ran depreciation on Fixed Assets and then the General Ledger posting routine. She realized that some of the assets were set up incorrectly and she needed to make changes on the Fixed Asset book setup.

continue reading... |

Microsoft Dynamics GP Tip: Using Reconcile to GL

When your A/P, A/Record or cash sub ledgers don’t match your General Ledger, the GL reconcile can show you where you have missing or “unmatched” transactions.

continue reading... |

Microsoft Dynamics GP with Excel Tip: Create a Pivot Table for General Ledger Data

Once you export your General Ledger report from Microsoft Dynamics GP to Microsoft Excel there is so much you can do with it. This video will show you a few helpful tricks around pivot tables. Pivot tables are the best way to summarize large amounts of data and focus on the information you need.

continue reading... |

Microsoft Dynamics GP Tip: Using the Account Rollup Inquiry Screen to Summarize GL Activity

Download and Print: Using the Account Rollup Inquiry Screen to Summarize GL Activity Creating an Account Rollup Inquiry option Use the Account Rollup Inquiry Options window to define the segment ranges and types of information you want to view in the Account Rollup Inquiry window. This is a nice companion feature to use with Accounts […]

continue reading... |

Microsoft Dynamics GP Tip: Using Budget Template in GP (Exporting & Importing)

  Download and Print: Microsoft Dynamics GP-Import/Export a Blank Budget EXPORTING A BLANK BUDGET Go to Financial>>Cards>>Budget Choose New Then Using Budget Wizard for Excel NEXT Fill in an ID for this budget For Frx budgets make sure that the budget name if it has a space use and underline 2010_Budget Name the Fiscal Year […]

continue reading... |

Microsoft Dynamics GP Tip: Adding Customer/Vendor Info to GL Transaction SmartList Favorite

STEP 1: Open SmartList. STEP 2: Click on Account Transactions STEP 3: Click on Columns STEP 4: Click ADD STEP 5: Scroll to “Originating Master ID” STEP 6: Hold down CTRL and select “Originating Master ID” and “Originating Master Name” STEP 7: Click OK>OK STEP 8: Save by clicking FAVORITES. Enter a name and click […]

continue reading... |