Updating Transactions through CSV Import

To update transactions through CSV import:

1. Use your own saved search or customize the Philippines Recovered Uncollected Receivables saved search to display transactions where the Bad Debt and Recovered Bad Debt boxes are blank. For information about creating or customizing saved searches, see Defining a Saved Search.

2. Export the saved search results to a CSV file. For more information, see Exporting Search Results.

3. Upload the CSV file through the Import Assistant. For more information, see Importing CSV Files with the Import Assistant.

4. On the Field Mapping page of the Import Assistant, do one of the following:

   • To update journal entries, select either Bad Debt or Recovered Bad Debt and set its default value to Yes to check the corresponding box on imported journal entries.

     Note:

     Don't select both Bad Debt and Recovered Bad Debt fields at the same time. To mark the other box for different journal entries, rerun the CSV import.

   • To update payments, set the default value of the Recovered Bad Debt field to Yes.

5. Click Save & Run. Repeat the steps until all affected records are updated.

Related Topics

• Philippines Quarterly VAT Form 2550Q
• Box 35: Output VAT on Uncollected Receivables
• Box 36: Output VAT on Recovered Uncollected Receivables
• How Output VAT is Displayed in Search Results
• Updating Transactions through Mass Update

General Notices