Skip to main content
When importing your chart of accounts from Oracle NetSuite, Xero, or QuickBooks Online, Francis does not currently include a retained earnings account. Manually calculating retained earnings is therefore necessary on your balance sheet for these entities.
Including retained earnings for Netsuite, Xero and Quickbooks Online is scheduled for release during 2025. If you have questions about this upcoming feature, feel free to reach out at [email protected].
To calculate retained earnings, add net profit (or loss) to the beginning retained earnings balance: 
// Example
= "Retained earnings"[-1] + "Net profit"[0]
If currency conversion is enabled on your NetSuite, Xero, or Quickbooks connection, the retained earnings formula must account for differences between average and closing exchange rates:
  1. Retained earnings (starting value): Adjust to the new month’s closing exchange rate.
  2. Net profit (current month): Convert from the average exchange rate to the closing rate. 
// Currency conversion example
= "Retained earnings"[-1] / "Exchange rate - closing"[-1] * "Exchange rate - closing"[0] 
+ "Net profit"[0] / "Exchange rate - avg"[0] * "Exchange rate - closing"[0]