Copy
News and tips for Sage 50 (formerly Peachtree), Excel, and whatever other general nerd knowledge I think will help computer users be more productive.

IQ Accounting Solutions LLC

November 2017 News & Tips

 
NEWS   SAGE 50   EXCEL
2018.1 Update

Rate increase coming 1/1/18
  Resolving a conflict with the Windows 10 Fall Creators Update   Centering Text Across Multiple Columns in Excel Without Merging Cells



News

2018.1 Update for Sage 50: In November Sage released an update to Sage 50 2018. All users with a current subscription or Business Care Plan should be automatically notified when it is ready to be installed. If you don't want to wait for it you can go to the Services menu and choose Check For Updates. The new features in this update only apply to Sage 50c users, in other words, those with a subscription license, not a traditional license. For more on the difference see http://www.iqaccountingsolutions.com/blog/sage-50c-vs-sage-50-straight-answers/

New feature are:
  • Sage Bank Feeds - Allows you to easily and securely establish an online connection with your bank to download activity from your bank into the Account Reconciliation window in Sage 50. This provides an automated alternative to manually marking payments and deposits as cleared or downloading an .OFX or .QFX file from your bank and importing it into the account reconciliation window. Like the manual import process, bank feeds simplify the process of matching up the transactions in Sage 50 with the transactions from your bank and and ensuring that all transactions on your bank statement are accounted for in Sage 50.
  • Sage Dashboard and Office 365 enhancements - Sage Dashboard is a new app that makes graphs and charts for Accounts Payable, Accounts Receivable, and Revenues/Expenses available in Office 365 so you can view the dashboard anywhere you have internet access (requires both Sage50C and Microsoft Office 365).
  • Cloud & Mobile Navigation Dashboard - Sage 50 now includes a new Cloud & Mobility navigation center that provides access MS-Office 365, Sage Drive, and Sage One integration.

Sage released this video explaining the new features.



Rate Increase Coming January 1st: If anyone ever needed evidence that accountants don't like change, the fact that I've gone nearly 10 years without raising my rates should be proof enough. But beginning in 2018 my regular hourly rate will be increasing from $120/hour to $135/hour. That will make phone support $2.25 per minute. After hours/weekend/holiday rates will continue to be 1.5 times the regular rate.




Steve Collins
IQ Accounting Solutions LLC
918-851-9713
scollins@iqaccountingsolutions.com
www.iqaccountingsolutions.com


A complete archive of these tips is available at http://www.iqaccountingsolutions.com/blog
 
 

Sage 50/Peachtree Tip - Resolving Conflicts with Windows 10 Fall Creators Update


Some Sage 50 users have started experiencing problems after an automatic update from Microsoft to Microsoft Windows 10 version 1709 (commonly referred to as the Fall Creators Update). This results in the error "Sage 50 Accounting has stopped working". Often it comes up when launching a task in Sage 50. Sage is working on a way to permanently resolve the conflict. But fortunately for all of you, if you're experiencing this there's an easy way to get your Sage 50 working again. You simply need to run Sage 50 in compatibility mode. Just follow these steps:
  1. Right-click the Sage 50 Accounting icon on your desktop and select properties.
  2. Click the Compatibility tab.
  3. Check the box located in the Compatibility mode section and select Windows 8 from the drop down menu.
  4. Click OK to save your change and close the Properties window.
Launch Sage 50 from the desktop icon and it should work like normal again.


  Google Plus One Button Forward To A Friend
 
 

Excel Tip - Centering Text Across Multiple Columns in Excel

Almost every Excel user knows how to center the contents of a cell using the button on the toolbar.  But that only lets you center within a cell.  What if you want to center a heading above a table that is several columns wide?  That's where a formatting option called "Center Across Selection" comes in.

For example, if you have 4 columns of data in Excel, there is no center column so you can't use it to center your heading.  Instead, enter your text at the top of the first column.  Then highlight that cell and the next 3 cells to the right so you have highlighted all 4 cells at the top of your table.  Now right-click in the highlighted area and choose Format Cells from the menu.  On the Alignment tab of the formatting window open the drop-down list for horizontal text alignment and choose Center Across Selection.  Click OK to close the window.  The text you entered in the first column will now be centered across all four columns.

Another option would be to use the Merge & Center button that is in the Alignment section of the Home ribbon. You would still highlight the cells you want to center across, then just click the Merge & Center button. But Center Across Selection is the better solution in almost every case. Merge & Center merges the highlighted cells so they behave as one cell which can interfere when selecting cells or navigating. Center Across Selection centers the text but does not merge the cells, allowing you to apply other formatting to or enter other text in the other cells in the range.



  Google Plus One Button Forward To A Friend
 

If you know other Sage 50/Peachtree users, do them (and me) a favor and pass this along to them. If you are someone that this has been passed on to, and would like to be added to my email list, you can subscribe for free at www.iqaccountingsolutions.com/signup.html or send me an email at newsletter@iqaccountingsolutions.com. If you need to change your email address or would like to unsubscribe, you can use the links at the end of this email.

Steve Collins
IQ Accounting Solutions LLC
918-851-9713
10611 E 17th Place
Tulsa, OK 74128
 
Copyright © 2017 IQ Accounting Solutions LLC, All rights reserved.
Email Marketing Powered by Mailchimp