importing various customer beginning balances

SUGGESTED

What is the Procedure to import various customer beginning balances when a new company is just set up in Sage 50

  • 0
    SUGGESTED

    Some people hand enter them because it's a pretty quick process. You just go to Maintain Customers, click on the History tab, then click the Customer Beginning Balances button. If you didn't already have a customer selected in Maintain Customers, you'll have to choose one from the list. Then go to the "Invoices For" tab and enter the invoice number, invoice date, amount, and AR account for each open invoice. You can also enter the customer PO number if needed. Repeat that for each customer.

    It goes fast since you don't enter all of the invoice details. But if you have enough beginning invoices that you want to import them, the best method is to hand enter at least one as a sample. Then go the File menu > Select Import/Export > Account Receivable > Sales Journal and click the Export button to export the entry you just made. Don't change anything on the Fields tab but sure to select Include Headings on the Options tab. After you export the file, open it in Excel and copy your beginning balance data into the appropriate columns using your sample entry as an example.

    ALWAYS MAKE A BACKUP OF YOUR SAGE 50 DATA BEFORE IMPORTING.

    Once your file is built, go back to the File menu > Select Import/Export > Account Receivable > Sales Journal and click the import button. Go to the Options tab, check "First row contains headings", select your file, and click OK to import your file.

  • 0 in reply to StephenC

    Thanks for the response. I will follow your guideline on Import/Export feature.