Skip to main content
E
ertaylor
February 2, 2023
Question

Entering Batch Credit Memos

  • February 2, 2023
  • 2 replies
  • 0 views

Hello - 

 

We are a nonprofit using QB Desktop Enterprise. 

 

Typically, we have a donations platform which I have to manually enter donations to specific Customers/Jobs. When I use the batch enter feature, I make sure the CM being created is going to the correct account. After I save the entries, I review the Balance Sheet to find these CM's are going to an incorrect A/R account. This just happened within the last 2 months. Maybe something changed within an update? 

 

Disclosure - it is too time consuming to enter these CM's individually. Generally, we process approximately 225 CM's like this a month. It has been as high as 300. 

2 replies

J
JamaicaA
February 2, 2023

I understand that your nonprofit CMS can make a huge difference in the success of your organization, @ertaylor. I'll help you record them into the correct A/R account.

 

When you set up a company file, QuickBooks automatically adds accounts to your chart of accounts that fit your business. Based on the columns, we're unable to select which account the credit memos will be recorded. That's why they're posted to the default A/R account.

 

Take a look at this article to learn more about copying multiple transactions such as checks, deposits, and other transaction type: Accountant tools: Batch enter transactions.

 

If you're looking to do other tasks after making the correction, feel free to visit our website: Learn QuickBooks Desktop. They have detailed steps on handling customer sales, vendors, company data, and more.

 

Keep in touch if you need any more assistance with this, or there's something else I can do for you. I've got your back. Stay safe.

Fiat Lux - ASIA
Fiat Lux - ASIA
February 3, 2023

@ertaylor 

You can prepare Credit Memo data with the following template

CustomerTransaction DateRefNumberPO NumberTermsClassTemplate NameTo Be PrintedShip DateBillTo Line1BillTo Line2BillTo Line3BillTo Line4BillTo CityBillTo StateBillTo PostalCodeBillTo CountryShipTo Line1ShipTo Line2ShipTo Line3ShipTo Line4ShipTo CityShipTo StateShipTo PostalCodeShipTo CountryPhoneFaxEmailContact NameFirst NameLast NameRepDue DateShip MethodCustomer MessageMemoItemQuantityDescriptionPriceIs PendingItem Line ClassService DateCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureAR AccountCurrencyExchange RateSales Tax Code
ABC Wallpaper01/10/202030 Net 30  Y ABC Wallpaper1 Main Street  AnytownNY12345USAABC Wallpaper1 Main Street  AnytownNY12345USA(123) 456-8789  John Smith     Thanks for ordering! Misc Supplies1Misc Supplies10             Non
Jones Hardware01/10/202031 Net 30  N Jones Hardware12 Smith Road  AnytownNY12345USAABC Wallpaper1 Main Street  AnytownNY12345USA(999) 999-9999  Jane Doe     Thanks for ordering! Hardware1Hardware2000             Non
Jones Hardware01/10/202031 Net 30  N Jones Hardware12 Smith Road  AnytownNY12345USAABC Wallpaper1 Main Street  AnytownNY12345USA(999) 999-9999  Jane Doe     Thanks for ordering! Paint1Paint 15             Non
Jones Hardware01/10/202031 Net 30  N Jones Hardware12 Smith Road  AnytownNY12345USAABC Wallpaper1 Main Street  AnytownNY12345USA(999) 999-9999  Jane Doe     Thanks for ordering! Door Knobs1Brass Door Knobs5             Non
Bank of Anywho02/10/202032 Net 30  N Bank of Anywho1800 State Street  AnytownNY12345USABank of Anywho1800 State Street  AnytownNY12345USA(888) 888-8888  Mr. Jones       Light1Fancy Light50             Non

 

then utilize one of these importer tools to proceed

https://get.transactionpro.com/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

 

Terms & ConditionsAccessibility statement