Furniture Accounting: Cool Tools

1. Furniture Accounting: Cool Tools

2. Welcome Connect Conference 2013 This is an exciting opportunity for everyone involved. The benefits go beyond just training and education—collaborate with your peers and inspire others around you. educate • collaborate • inspire

3. Furniture Accounting: Cool Tools In this session, we will review the Furniture post to P/O feature, import A/R remittance, import G/L from an Excel spreadsheet, and the General Ledger drilldown.

4. Furniture Accounting: Cool Tools A/P: Furniture Post P/O • Receive P/O • Verify and/or Bill Sales Order • Post the A/P Invoice

5. Furniture Accounting: Cool Tools A/P: Furniture Post P/O • Additional Limits • Open P/Os Only • Project and Order #

6. Furniture Accounting: Cool Tools A/P: Furniture Post P/O • Make changes to purchase order and sales order • Change order • Receive product • Initial or Final Verify (bill) sales order

7. Furniture Accounting: Cool Tools A/P: Furniture Post P/O

8. Furniture Accounting: Cool Tools A/R: Import A/R Remittance Import Check Remittance data from a customer or from the bank • Excel required columns and formatting • \DDMS\Client\Data\Templates\ar remittance import template.xlt • Required fields are: Invoice Number, Check Number and Amount Paid • Convert General Column to Text

9. Furniture Accounting: Cool Tools A/R: Import A/R Remittance • Importing Data • Input G/L control number and batch information • Manage exceptions

10. Furniture Accounting: Cool Tools A/R: Import A/R Remittance • Exceptions • Leading C Removed for Credit: If the invoice begins with a C in the first position, the system searches for the invoice without the leading C. If found, the remittance information is posted to the invoice number without the leading C. An exception is logged. • Suffix Inserted Into Inv #: If the invoice does not contain a dash number, a dash is added before the last digit and search performed on the account. If found, the remittance information is posted to the invoice with the dash. An exception is logged.

11. Furniture Accounting: Cool Tools A/R: Import A/R Remittance • Exceptions Continued • User Assigned Account #: If the customer account shown on the spreadsheet cannot be found in the system, you must select the account. An exception is logged. • Invoice Created: If the customer account shown on the spreadsheet exists but the invoice does not exist, the remittance is posted to the account for the invoice. An exception is logged. • Account # Changed From Invoiced Acct #: If the customer account shown on the spreadsheet is different from the system account for the invoice, the invoice is not posted to the system account. An exception is logged.

12. Furniture Accounting: Cool Tools A/R: Import A/R Remittance • Blank Account #s can be changed • Other exceptions must be corrected prior to import

13. Furniture Accounting: Cool Tools G/L: Import General Ledger Postings Import G/L postings from an Excel spreadsheet • Import beginning balances • Import monthly entries from an outside accounting firm • Make monthly reversing entries in Excel then import them into the DDMS system • Import budget figures into Chart of Accounts

14. Furniture Accounting: Cool Tools G/L: Import General Ledger Postings • Excel columns and formatting • \DDMS\Client\Data\Templates\ • Column names must be the same as the template provided, but can be in a different order • Convert columns to text where any fields should keep the leading zeros

15. Furniture Accounting: Cool Tools G/L: Import General Ledger Postings • Importing data • If the spreadsheet contains multiple worksheets, they are imported in order by their name. For example, worksheet A will import before worksheet B • Enter batch information • Exceptions will display in red and must be corrected before importing

16. Furniture Accounting: Cool Tools Don’t forget to turn in your session survey for a chance to win a $250 gift certificate Surveys can be turned in at the Conference Registration in the Trinity Foyer or in the Lab located in the Pegasus Ballroom (both located on the lobby level)

17. Furniture Accounting: Cool Tools

18. Customer Service & Support Contact Information • Support • 800-366-4778 • Monday – Friday • 7AM-7PM CST • Training • 800-959-3367 Option 5 • professional.services@ecisolutions.com • Virtual class training • One on One training • Onsite training